I took SQL down.
Copied the mdf file called abc_data.mdf to another directory.
Brought SQL up.
Dropped the database ABC.
Created a new databse called ABC.
I took SQL down.
Copied the old abc_data.mdf from another directory and pasted it over the new abc_data.mdf.
Brought SQL up.
Open Enterprise manager.
ABC database was suspect.
-----Original Message-----
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:42 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue
Just to verify...
You had two files in your originals DATA directory, lets assume the path is
E:\Program Files\Microsoft SQL Server\MSSQL\Data
Ok, your two original files were
Sample_DATA.MDF
Sample_LOG.LDF
You then deleted the LDF file on accident.
Ok, so then you created a new Database, let's call it Foo.
You then stop the sql server. You now have 2 new files:
Foo_DATA.MDF
Foo_LOG.LDF
You then deleted Foo_DATA.MDF and took Sample_DATA.MDF and renamed it to
Foo_DATA.MDF.
Then when you restarted the Db it gave you an error?
That is really freaky, let me double check my instructions but that is
exactly how I do it here. I may have missed a step though.
-----Original Message-----
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:30 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue
I did that and got an error message telling me that the database names were
different. think it was error 5173
-----Original Message-----
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:19 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue
Ok, first try this::
sp_resetstatus
If that does not work you might try the following::
1. Turn off the SQL Server,
2. Copy the data file to a secure location on the drive
3. Turn on the SQL Server
4. Create a new database, call it foo or something
5. Turn off the database
6. Look in the /Data/ directory (or wherever you place your DB's). You
should see the FOO Data and Log files. Overwrite your backup data file you
moved earlier in Step 2 and replace it exactly with the Data name of Foo.
7. Turn on the database, and try to access FOO. That should work
That should work, at least it has for me in the past
<http://intranet>
Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101
Office Phone 606.920.7447
Cell Phone 606.831.4590
-----Original Message-----
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue
Unfortunately the last back up I had was from 11/28. This all happened
yesterday. And yes the .ldf file was deleted.
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue
you deleted the ldb file?
uhhh, hmm, do you have a backup?
tw
-----Original Message-----
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:06 AM
To: CF-Talk
Subject: OT-SQL Data file issue
Ok I made a big mistake. I had a database set to FULL thinking it was set to
SIMPLE and forgot to set up a job to truncate the transaction log. Needless
to say, the transaction log grew huge (14g) and sucked up all my memory. So
I took the database offline and deleted the file and replaced it with a new
empty one. Well that made my database suspect. How can I fix this?
_____
_____
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
