Viewing 9 posts - 106 through 114 (of 114 total)
James Morrison (9/22/2008)
Here is what I found out.Recovery Model is Full
Database backup is Full ( run at 9 PM)
Transaction Log backups are daily at 12 PM CST
This is why your...
September 22, 2008 at 1:34 pm
Shubh Chandra Jha (9/22/2008)
a)Full --...
September 22, 2008 at 2:41 am
James Morrison (9/21/2008)
Veritas is our backup software and the logs are not being shrunk after the completes.
A backup alone will not shrink the log files - ever.
You can free...
September 22, 2008 at 2:29 am
Heheh.
I guess what it all boils down to is that a real DBA will always have a real DB backup. 😉
September 4, 2008 at 6:24 am
Fearless and clueless is a very dangerous combination...
What he should have done is of course to detach the DB, move the files and then attach the DB with the files...
September 1, 2008 at 3:56 am
Quote:
"This is the latest one after march 05 the 2007, http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en "
Actually no, it's not. That's version 9.00.3050. I have 9.0.3159 and there are newer versions after that one...
August 10, 2007 at 5:59 am
In my opinion, Microsoft is not very good at helping us keep track of all their new versions, releases, service packs and hotfixes - it's more or less a jungle out...
August 10, 2007 at 5:54 am
Okay, I just tried it and I stand corrected: No, you can NOT restore anything backed up from a 2005 server on a 2000 server.
As for compatibility level, this can...
August 10, 2007 at 5:01 am
Actually, I believe you can - if, and only if - you change the compatibility level of the database on SQL Server 2005 before making the backup. I have not tried...
August 10, 2007 at 4:04 am
Viewing 9 posts - 106 through 114 (of 114 total)