Viewing 15 posts - 38,776 through 38,790 (of 49,552 total)
First the full backup, then the last differential, then all of the logs, in order. Restore them all with the NORECOVERY option then, once you're certain that you have all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2009 at 1:28 am
NathanB (5/31/2009)
Hey guys, I believe Julio created a new Topic instead of replying in http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx.
Nah. This one and the one you reference were started at the same time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2009 at 1:24 am
Shripad (6/1/2009)
I can restore the backup, its too easy to tell but its difficult to loose the data. My friends didn't took backup when i was on leave. I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2009 at 1:22 am
The line you posted looks fine. Please post the entire script.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 1:14 pm
If you want to know which tables your custom script has rebuild, add something in to the custom script to log that. If you want to see the fragmentation level...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 1:08 pm
As I said
When set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database automatically reopens when a user tries...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 9:53 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 9:50 am
It won't be suspect anymore, but you'll still have lost all of your jobs, backup history, DTS packages, SSIS packages and whatever else is stored in msdb.
Personally, I'd rather say...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 9:48 am
Books online says this:
When set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database automatically reopens when a user...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 9:45 am
Table definitions, index definitions and execution plan (saved as a .sqlplan file, zipped and attached) please.
I'll be blunt, that query will not perform well and there's probably not much that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 7:26 am
_simon_ (5/31/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 7:23 am
Have you checked that the database is been restored to the large drive and not to C?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 3:09 am
_simon_ (5/31/2009)
Thanks for your reply, I changed my code, hope it is OK now:
You sure that a customer's name will be unique?
What indexes should I create on table BillOfMaterials?
Very hard...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 2:56 am
Stupid question, but is there enough space on the disk for the files you're trying to put there? It's possible that the restored database will be larger than the backup...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 2:53 am
You should not be trying to backup the SQL data and log files using NTBackup. The files are locked by SQL server and either NTBackup will skip them or it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 2:51 am
Viewing 15 posts - 38,776 through 38,790 (of 49,552 total)