Viewing 15 posts - 151 through 165 (of 306 total)
No answers just questions, When you back up your transaction logs do you do it with verify the integrity? Did you review the production side of this, the error...
April 25, 2003 at 12:05 pm
I don't see how this helps - did you see
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b275901
quote:
SQL 2000 sp 3
April 24, 2003 at 12:51 pm
gfahrlander your mean!!! You kill without warning. I'm sure you'd make my internet community real happy.
John Zacharkan
April 23, 2003 at 2:12 pm
quote:
Did you say you can do it in SQL Server 7.0?
On SQL 7.0 I...
April 23, 2003 at 1:09 pm
quote:
Do you have to use maintenance plan to fix database minor problem? You can run dbcc checkdb with repair options and schedule...
April 23, 2003 at 12:10 pm
How can that be an option in the database maint plan then?
quote:
Don't choose repair minor problem, that needs database in single...
April 23, 2003 at 11:32 am
Sounds like you have a few records. If you have enough disk add the varchar col under a different name, move the nvarchar to the new col; batch process...
April 7, 2003 at 8:44 am
I'll send you an example in the morning.
quote:
I don't think DTS will let me copy to the same server, unless I...
April 2, 2003 at 5:10 pm
Sorry for the confusion.
You rename the system mdf & ldf database files after the services are stop.
Andy mention copying all mdf and ldf files. If you have a...
April 2, 2003 at 5:09 pm
hmmm DTS - one way
John Zacharkan
April 2, 2003 at 1:35 pm
At this point I would kill the the spid restoring the database.
Does sp_who2 show you the restore in progress? If it does I would kill it, then delete...
April 2, 2003 at 1:26 pm
From master - -Did you get this after you ran
RESTORE DATABASE yourdatabasenamehere With Recovery
quote:
Can't do anything with the database:Server: Msg...
April 2, 2003 at 1:02 pm
Viewing 15 posts - 151 through 165 (of 306 total)