Viewing 15 posts - 15,691 through 15,705 (of 49,552 total)
In management studio, select results to file and specify the file name.
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
November 13, 2012 at 12:40 pm
Nope, that's pretty much how it's done.
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
November 13, 2012 at 12:36 pm
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1384236-392-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
November 13, 2012 at 12:36 pm
Not yourself.
Click 'Report!' in the top-right corner and in the text box ask for the thread to be moved and specify where you would like it moved to.
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
November 13, 2012 at 12:34 pm
You can check if there are any locks at all on a table by looking at the sys.dm_tran_locks table, but somehow I don't think that's the real question here.
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
November 13, 2012 at 11:50 am
Pretty much right. Just watch out for large data loads and index rebuilds for taking lots of log space.
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
November 13, 2012 at 9:55 am
Abu Dina (11/13/2012)
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
November 13, 2012 at 9:40 am
Abu Dina (11/13/2012)
Also, can I just confirm that by shrinking the log file from 26GB to 1GB for example, my backup will also reduce by the same size?
No. Probably unaffected.
Backups...
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
November 13, 2012 at 9:23 am
Could you explain your need in more detail please? 'reopen'???
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
November 13, 2012 at 8:26 am
djackson 22568 (11/10/2012)
GilaMonster (11/10/2012)
djackson 22568 (11/9/2012)
GRIN For all those asking for it in Europe, bah humbug! Keep it here.
You do know that Red Gate is based 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
November 13, 2012 at 7:57 am
marygrace_laurente23 (11/12/2012)
Error:
System.Data.SqlClient.SqlError: The log in this backup set begins at LSN #, which is too recent to apply to the database. An earlier 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
November 13, 2012 at 5:42 am
Bill Talada (11/9/2012)
I like your idea of IFs in a stored procedure since each option may be optimized separately.
If you're talking about straight queries within IF blocks, they won't be...
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
November 12, 2012 at 2:20 pm
Welsh Corgi (11/12/2012)
After I restore with recovery what steps are required to upgrade other then setting the Compatibility Level?
None are required, not even setting the compat mode is required.
You probbaly...
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
November 12, 2012 at 1:32 pm
Can't be done.
In an upgrade setup, the database can only be restored with NORECOVERY or WITH RECOVERY (which ends the restore sequence)
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
November 12, 2012 at 1:25 pm
Database corruption is notn something that SQL can or will do itself. It's something that's caused by misbehaving components, usually in the IO subsystem.
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
November 12, 2012 at 1:21 pm
Viewing 15 posts - 15,691 through 15,705 (of 49,552 total)