Viewing 15 posts - 376 through 390 (of 860 total)
Alfredo Giotti (4/1/2009)
I appreciate your response. When rerunning DBCC CHECKDB the output displays no corruption.
Alright! Did you fix that? Or have you made a restore from a clean backup? Could...
April 1, 2009 at 8:22 pm
Have you got a clean backup?
Page (1:303495) , Page (1:303512),Page (1:303513),Page (1:303514),Page (1:303515),Page (1:303516),Page (1:303517),Page (1:303518)
You have got corruption on the following pages. You can do a page level...
April 1, 2009 at 8:04 pm
Is that a typo? it should be mdf not pdf
CREATE DATABASE Adventureworks
ON FILENAME ='your path'
FOR ATTACH
or
Right-click on Databases and select Attach.
Click the Add button and select the database...
April 1, 2009 at 5:09 pm
No, that should be enough if you are the owner of the job you should be able to modify the job and also a sysadmin can.
April 1, 2009 at 4:59 pm
What are you trying to copy here? Application DB or master?
Why don't you copy and restore the DB and then carry on from there?
April 1, 2009 at 4:48 pm
wallynut (4/1/2009)
We have a task which occurs frequently in the database (Server 2005) which does a huge amount of changes to a number of temporary tables and this in turn...
April 1, 2009 at 4:17 pm
GilaMonster (4/1/2009)
K
In addition, the error received in the situations where that is the case is completely different from the one Tim reported.
Oh! thanks Gail you clarified it, I was a...
April 1, 2009 at 4:08 pm
TimC (4/1/2009)
April 1, 2009 at 3:42 pm
TimC (4/1/2009)
The log in this backup set begins at LSN 24000000020700001, which is too recent to apply to the database. An earlier log backup that includes LSN 24000000020000001 can be...
April 1, 2009 at 3:07 pm
Edd (4/1/2009)
I thank you very much. I'll feel a lot better after I have a good backup of the database. You got me close enough to figure it...
April 1, 2009 at 2:31 pm
Edd (4/1/2009)
I gave the backup location a filename and the bak extention. Is seems to be running. At least I have no error message, yet!
That's good enough!
April 1, 2009 at 2:25 pm
ebenraja (4/1/2009)
Hi All,When we ran DBCC CHECKTABLE statements against certain specific tables in the db the server gets restarted.
Yes as Gail suggested, Why are you running this anyway?...
April 1, 2009 at 2:18 pm
Have you go the folder created? You should create the folder and create hte .bk file
For example if your database name is 'Mydatabase'and you want to back it up to...
April 1, 2009 at 2:13 pm
Edd (4/1/2009)
OK I ran thisBACKUP DATABASE 'mydatabase' TO DISK='E:\SQL Backup'
and I get his response
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'mydatabase'.
oops sorry that...
April 1, 2009 at 2:03 pm
But why does it matter to you though whether is it _log or _1??
Why don't you restore using the TSQL?
April 1, 2009 at 1:57 pm
Viewing 15 posts - 376 through 390 (of 860 total)