Recover Used But Useless Auto IDs

Mar 3, 2008

Greetings.

Currently I have the following setup:

My table uses the identity of +1, and starts at 1 for a primary key.

These are ticket numbers, and each time a new ticket is created a number is taken, currently at around 45.

When a ticket is opened and cancelled I decide to just set a status column for that ticket number to cancelled. Therefor a ticket remains in the database that offers no use (we don't want cancelled tickets cloggin.)

using an SSIS package to delete is pretty simple, just Delete from Table Where Status = 0 (or cancelled).

Then I will have some numebrs from the past I would like to recover.

For example, my ticketnums table could read that I am using tickets 1, 4, 7, 8, 9, 11.. etc

Tickets 2,3,5,6,10 are cancelled, can I recover these ticket numebrs?

Thanks in advance

- Brad

View 4 Replies


ADVERTISEMENT

SQL Server Admin 2014 :: Auto Recover Files Not Being Created

Aug 15, 2014

I have set the environment set for AutoRecover (for every 3 minutes and Keep information for 7 days under the SSMS 2014 Menu: Tools -> Option ->Environment -> AutoRecover).

I've rebooted the box and restarted the SQL Server service and nothing seems to create the files.

View 4 Replies View Related

Query Governor Pretty Useless?

Aug 17, 2007

I know that the query governor works off of estimated query plans, but the estimation is usually so far off from reality that it might as be generating a random number to determine whether a query should run.

Right now I have query governor set at 300. I've been able to run queries that take more than 10 minutes without any complaint from query governor.

What's really annoying though, is that it has also blocked queries that take less than a second to run. It blocked a query for having an estimated executing time of 338 seconds. When I set the limit up to 400, the query ran virtually instantly.

Is this just how query governor is suppose to work? Is there any way to make it work better?

View 3 Replies View Related

Date Picker RS2005SP2 Useless

Jun 15, 2007

I read a lot of posts in this forum, but none of them provide a solution.

Probably it is related to SP2 as many report, I have SP2 as well...



A funny situation:
I have a report parameter @date, datatype datetime, so I can use the datepicker control.

But, even when not using this @date parameter in my dataset, I still get the error:

The value provided for the report parameter 'date' is not valid for its type. (rsReportParameterTypeMismatch)

Of course it has to do with regional settings and languages etc... But at my international client's site, workstations are in any regional setting and servers are in en-US, nothing I can do about that.



Come'on Microsoft, don't tell us this datePicker is only for the US market?





View 1 Replies View Related

Cryptic And Useless SSIS Error Messages

Aug 22, 2007

First of all, please let me prefix this by saying AAARRRRRGGGGGHH!!!

Troubleshooting an SSIS package is not even close to easy. The error messages are incredibly cryptic and are anything but useful. It is absurd that for most of the errors that I get, I find myself putting the error codes into Google to find out what they mean and how to address them. Since there is indeed an known exception, why not include a "descriptive" description of the error?

Okay, enough with the venting. Sorry about that...

What I really came here to ask is this, what in the world does this error message REALLY mean? I have found nothing useful on the Internet so far. The resulting forums and blogs with the error code do not apply to what I am doing.

Error: The attempt to send a row to SQL Server failed with error code 0x80004005.

- - - -
- Will -
- - - -
http://www.strohlsitedesign.com
http://blog.strohlsitedesign.com/
http://skins.strohlsitedesign.com/

View 20 Replies View Related

SQL 2012 :: SSMS Auto-recovery / Auto-save New (unsaved) Queries

Feb 16, 2014

Since upgrading from SQL Server Management Studio 2008 R2, I've noticed that it no longer autosaves queries that have not been manually saved first. If a file has been manually saved the autorecover files end up in the following directory:

%appdata%MicrosoftSQL Server Management Studio11.0AutoRecoverDatSolution1

However, I have ended up in the situation where I have unsaved queries when my computer has crashed and have not been able to recover them.

I have also found references to .sql files stored in temp files in the following directory, but the files here seem to be very haphazardly caught:

%userprofile%AppDataLocalTemp

View 2 Replies View Related

Auto Increment Auto Non-identity Field

Jan 23, 2004

I have an MS SQL Server table with a Job Number field I need this field to start at a certain number then auto increment from there. Is there a way to do this programatically or within MSDE?

Thanks, Justin.

View 3 Replies View Related

SMO Recover DB

Feb 2, 2007

Is there a way to recover the database without defining a device to restore from?

Restore Database TestDB With Recovery

MTmace

View 4 Replies View Related

Recover From T-Log

Feb 1, 2008



Hi,

By mistake i've damaged my .mdf file and i have no backup on this database . However i have the transaction log intact and an older version of the database .

Is it possible to recover the database using the transaction log? How can it be done?

I do not have the transaction log backup, just the .ldf file.



Thanks to anyone who can help me.

View 6 Replies View Related

Recover Database

Feb 27, 2000

How do I begin? I had previously installed the SQL Server 7.0 with NT Authentication and everything was fine until I Rename domain Name and Computer name. I decided to uninstall SQL Server, and then reinstall it.
From this action unable to see my database in enterprise manager. I Rename old domain and computer name again. and reinstall with Upgrade Version. but still same effect. Can anyone help? What do I need to do to get my database to work again? Any input on this will be appreciated. Thanks in advance.

View 1 Replies View Related

How To Recover A Database?

Aug 25, 2004

I had MS SQL installed on my comp.I had to reformat my hard drive due to some problems.There was a db in the sql server which i needed.So i saved the .mdf & .sdf files.Then i installed sql server in the formatted hard drive & pasted the .mdf & .ldf files in the Data forlder in MSSQL folder.But the problem is that even after doing this the enterprise manager doesnt show that database.Can anyone help me with this?Is there any way to recover the database?
Thanks a lot

P.S.- I also have whole of the earlier MSSQL folder present in the earlier program files backed up.Would that help in anyway.

View 3 Replies View Related

Recover The DTS Packages

Aug 5, 2004

Hello, everyone:

A guy think that the DTS packages can be recoved by restore MSDB database. Is that true? Does anyone have experience on that? Thanks.

ZYT

View 2 Replies View Related

Recover Database

Nov 23, 2004

Hi

I've had a powerfailure, that resulted in I had to scratch my DB server, I've managed to get all the .mdf and .ldf files from the server. On the new server I get a "Error 823: I/O error (torn page)" when I'm trying to attach the .mdf file to the New server.
Both the new and the old server is a win2003 with SQL 2000 SP3

Is there anybody who knows how I can recover the DB?

/Rune

View 1 Replies View Related

Recover Database Help!

Oct 6, 2005

Hello,

Is it possible to restore a SQL 2000 database with data from a transaction log?

I am not sure what happened to my database, all the data in the tables is gone. I generated a db script to create a duplicate database. I saved the .sql file on my local machine, separate from the db server, renamed the database name in the .sql file to a new database. Tested script in query analyzer for syntax, all was fine. Running it at this point would have created a new database with a different name, right?

Now my original database is empty. Can someone please provide me with information on getting my data back. Is there a way of using the transaction log to recover the data.

Thanks

View 2 Replies View Related

Log Shipping Recover

Jan 30, 2004

I have changed the roles of primary and secondary servers due to server failure.

Can anyone advise how to revert back to previous main server? Are these any links available?

View 2 Replies View Related

Recover DB From Its MDF And Ldf Files (HELP)

May 3, 2004

Hi
I need help to recover database from its MDF & ldf files as my server crahsed today .

BTW i installed afresh copy of MS SQL 7.0


I need to be able to restore the database. Pls reply if
you can help. It would be greatly appreciated.

:( :confused:

View 1 Replies View Related

Way To Recover A Database?

May 9, 2011

is there any way to recover a database? I accidently drop my database .I don't have any backup.

View 5 Replies View Related

How To Recover From A Corruption

Aug 5, 2005

Paul,

Having read your useful insight into the sorts of issues around the corruptions that folk have posted in this forum I'm interested in preparing for the day when one of our servers gets corrupted :-(

Should I expect to be able to:

Restore FULL backup from Before the corruption first happened
Restore all Tranaction log backups since

and would get me back to ground zero?

I'm thinking:

if I do a DBCC CHECKDB once a week, say, immediately after a FULL backup - then if that gives me some error messages I've got last weeks Full backup and a weeks worth of Trans Log Backups to restore - which is OK for a rare disaster.

I apprecaite that the thing that caused the corruption might be a memory or disk fault, which might also have broken the creation of the backup files too - in which case I'm fairly stuffed!

Does a RESTORE do a checksum of somesort that would detect a corruption caused by, say, a memory fault or a disk controller that wrote the block faultily [twiddled some bits, but did not report error]?

In which case continuous restores of backup files to A.N.Other server would discover the moment at which a backup was "known bad"

Am I close?

Thanks

Kristen

View 9 Replies View Related

How To Recover Pubs?

Feb 2, 2006

I am using sql server7.0
I want to know how to recover pubs and northwind data bases in case they are deleted.


Gajanan Kulkarni

View 2 Replies View Related

How To Recover The Data

Jun 22, 2006

raju writes "while attaching the mdf file we are getting the following error
error 823
i/o error (bad page id) detected during read at offset
0x0000001404000 in file d:filename"

View 4 Replies View Related

Distaster Recover

Mar 9, 2007

OS: Windows 2003 Standard Edition
MS SQL: Standard Server 2005

I am looking to implement a disaster recovery plan for an MS SQL 2005 server, this is what I have done so far but would like the benefit of your experience to provide feedback and help improve the strategy.

MS SQL Server:
I have two maintenance plans, one to backup the system databases to individual backup files (.bak) and one to backup all the user databases to a backup device (mssql_backup) The backup files & device are in a directory (backup) and is backed up using NFS. I keep a copy of the backups on a USB HD which is stored offsite.

Disaster:
Office burnt down

Recovery:
New server, install OS/MSSQL, patch up to same version as burnt server.

Copy .bak files to new server, copy mssql_backup file to same location as previously held i.e. X:ackupmssql_backup

Start MS SQL in single user mode, restore master database using .bak.

Start MS SQL in normal mode, restore other system databases using .bak

Restore user databases using mssql_backup device

Testing:

Using the above steps I was able to restore up to the point of "user databases" Getting to this point I realised that there are a number of databases to restore, in my novice ways this seems to be a lot of right-clicking and restoring.

1) is there a command that would in effect be able to restore all databases using the backup device?

2) do I have a working version of the databases to the point of the last backup? Or am I missing something?

3) in my current setup in mind (SQL backup to NFS directory and picked up my backup software) is there a 'better' way I could be doing this which would make the restoration procedure more efficient

View 4 Replies View Related

Recover Datbase

Mar 28, 2007

how can i recover sqlserver 6.5 datbase from tape.

pls help me?

View 1 Replies View Related

Recover SDF-File

Nov 4, 2005

Hi,

View 12 Replies View Related

Recover Database Password

Jul 23, 2007

Hi all,
Is it possible to recover or find the password of database or resetting is the only option? I have a database that has a two users in the Users tab. How to find out the password for these?
Thanks, 

View 4 Replies View Related

Recover Sql Server Database

Feb 1, 2008

Hi,
By mistake i've damaged my .mdf file and i have no backup on this database .  However i have the transaction log intact and an older version of the database .
Is it possible to recover the database using the transaction log? How can it be done?
 Thanks to anyone who can help me.

View 3 Replies View Related

Recover Scripts From SQL2005

May 13, 2008

Hi,
 
Some times my laptop will hang for some reason and i will have open few sql 2005 query editors working with scripts. I am loosing them if i restart my system. Is there any way to recover the previous instance of my sql 2005 query editors after restarting my system. Please let me know if yo have any idea to handle.
 
 
Thanks
Dilip

View 4 Replies View Related

Is It Possible To Recover A Dropped Table?

Jun 3, 2004

Hi All,
Accidentally I have dropped a table and that is the main table for my application.
I dont have a backup of it. Is there any way to recover it.Please help me guys.
Thanks,
Kumar.

View 1 Replies View Related

How To Recover My Procedure From SQL Server 7.3

Apr 16, 2002

Hello,

I have some procedure in SQL Server 7.3 they are
working fine. Now my SQL Server is not working that is
it not opening Query Analizer or any other tool
in SQL Server ok.
I have no back of my procedures which are written
in SQL Server any where like in notepad or in some
places.
Now i have a plan to load Sql server again
but i want my old procedures before loading
Sql Server again.

How to do it?
How to restore my procedures?
Where actually SQL Server stores these procedures?
I searched in my system with my procedure name but it
shows nothing with those names.
In my case there is no chance of recovering my old SQL Server
i have load again SQL Server.

So kindly help on this issue asap.

thanks

View 4 Replies View Related

Recover After Delete Statement

Sep 6, 2001

One of our developers just deleted a ton of records- is there any way we can recover this data? (we can't use a backup since a ton of changes were made since we last backed up)

Thanks-

Jack

View 2 Replies View Related

Database Backup And Recover

Jul 14, 2003

Hi all:
In order to test database restore, I create a backup driver and puporse delete one table, then I try to restore my databse use backup, but the delete table donot show up.

Thank you

View 5 Replies View Related

Recover A Replication Agent?

Mar 22, 2004

Hi Guys,

Ive accidently gone and deleted a snapshot agent off a working publication (tables distribution.dbo.mssnapshot_agents, msdb.dbo.sysjobs etc).

Is there a workaround to create a new snapshot agent for the publication without having to break or recreate the publication?


I have tried adding a snapshot and only to fail, can anyone help? thanks a million


---*** Tried adding a snapshot agent ***---
use publishing_database
go

-- Add snapshot job
exec sp_addpublication_snapshot @publication = N'publication_name',
@frequency_type = 4,
@frequency_interval = 1,
@frequency_relative_interval = 1,
@frequency_recurrence_factor = 0,
@frequency_subday = 8,
@frequency_subday_interval = 1,
@active_start_date = 20040101,
@active_end_date = 20040101,
@active_start_time_of_day = 0,
@active_end_time_of_day = 235959
GO


-- RESULT:
Server: Msg 14101, Level 11, State 1, Procedure sp_MSaddpub_snapshot, Line 73
The publication 'publication_name' already has a Snapshot Agent defined.

View 4 Replies View Related

Recover Deleted Records

Mar 22, 2005

I want to know what to do to recover the deleted records on a specific table. Unfortunately, the dba was unable to activate Trace feature and I am not familiar in using the transaction logs to retrieve data.

please help. :confused:

View 4 Replies View Related

How To Recover All Deleted Records

Feb 20, 2005

Hi everyone

Is there any way to recover all deleted records.

By mistakes i deleted all records.

Please help me out

Waiting for reply.

Thanx in advance

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved