Viewing 15 posts - 27,886 through 27,900 (of 49,552 total)
Shutdown shuts the SQL instance down, not a database. It's possible to detach a database and not have it cleanly shut down, primary example if the log is full.
Clean shut...
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
February 8, 2011 at 4:51 am
avinashily (2/8/2011)
use sp_attach_single_file_dbexample:
EXEC sp_attach_single_file_db @dbname = 'Avinash',
@physname = N'M:\Avinash.mdf';
sp_attach_db and sp_attach_single_file_db are both deprecated, included for backward compatibility with SQL 2000 and will be removed...
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
February 8, 2011 at 4:07 am
What will happen for the database 1,2 and 4 on Instance A?
They'll carry on running on Instance A.
How many databases can be mirrored as per server?
Depends. Network bandwidth, server...
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
February 8, 2011 at 1:14 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1060032-146-1.aspx
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
February 8, 2011 at 1:09 am
That's a vague question. Entire books have been written on the subject.
Start with these:
Then consider Grant Fritchey's book:
http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/
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
February 8, 2011 at 1:08 am
If you're asking for volunteers to analyse and recover, the chance is virtually 0. There are no more than a handful of people in the world capable of rebuilding a...
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
February 8, 2011 at 1:05 am
ITUSER60 (2/7/2011)
I think it is best to play it safe by the book and use the BAK files found on another partition.
I think that's probably the best bet. Keep...
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
February 7, 2011 at 10:22 pm
clare.xia (2/7/2011)
I can stop SQL server and rename the log file for MSDB and let it generate a new one and then delete the old log file.
There's a very good...
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
February 7, 2011 at 10:20 pm
ITUSER60 (2/7/2011)
I meant that it was from my BUE which backs up the file itself.
That is not the way to backup SQL Server and, if the 'backups' were taken...
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
February 7, 2011 at 2:56 pm
Why can't you add another log?
If you replace MSDB, you'll lose all jobs, job history, backup history, DTS packages, SSIS packages, agent alerts, etc.
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
February 7, 2011 at 2:53 pm
Tom.Thomson (2/5/2011)
Can you extend the log file, or allocate an extra log file?
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
February 7, 2011 at 2:41 pm
ITUSER60 (2/7/2011)
The LDFs are also missing from the backups
Err, when you take a database backup it includes mdf and ldf. There's no way to lose a ldf from a...
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
February 7, 2011 at 2:06 pm
Yes, I have seen it work (my test is in that blog post), I've also had feedback from people I've helped here that it worked.
It depends what's damaged and how....
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
February 7, 2011 at 8:42 am
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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
February 7, 2011 at 7:53 am
SuperDBA-207096 (2/7/2011)
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
February 7, 2011 at 6:28 am
Viewing 15 posts - 27,886 through 27,900 (of 49,552 total)