Viewing 15 posts - 30,046 through 30,060 (of 49,552 total)
Donalith (10/11/2010)
What about the difference between backup/restore and detach/(move files to new server)/re-attach?
Up to you. Advantage of backup/restore is that it leaves a copy of the DB available and usable...
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
October 11, 2010 at 2:31 pm
Donalith (10/11/2010)
In SQL Server 2008, could I not just use the Copy Database Wizard after setting the database to single user mode to recreate it on the new server?
You could....
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
October 11, 2010 at 2:10 pm
No restores will break the log chain on the source database, and that's the only log chain that matters.
What are you trying to achieve here? A read-only reporting database? 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
October 11, 2010 at 10:35 am
DELETE FROM <tablename>
or
TRUNCATE <TableName>
Both will remove all data from the table.
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
October 11, 2010 at 10:34 am
Are you talking about an identity column perhaps?
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
October 11, 2010 at 10:23 am
AndrewSQLDBA (10/11/2010)
So I can restore those other databases in a continuous loop, right after they are taken, and everything will be fine?
Huh?
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
October 11, 2010 at 10:21 am
shanila_minnu (10/11/2010)
Instead .MDF & .LDF files are backing up to tape on a daily basis.Here the principal database is in clustered environment
That is not how you take SQL backups. 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
October 11, 2010 at 10:10 am
Turn 1204 off. It's the old deadlock detection traceflag. The info provided by 1222 (also deadlock detection and new from SQL 2005) is far more detailed and far superior
Flag may...
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
October 11, 2010 at 10:07 am
If you kill the process it will rollback with the rest of the database available and usable. If you restart SQL then, unless you have enterprise edition, the rollback will...
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
October 11, 2010 at 7:39 am
Jack Corbett (10/11/2010)
I think the Red Lion(?) hotel is fairly inexpensive and close by (walking distance). I think Gail has stayed there.
I have, but it's hardly a cheap hotel....
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
October 11, 2010 at 7:36 am
shanila_minnu (10/11/2010)
I want to submit the root cause of this growing TLOG.Any sugessions
As has been said more than once on this thread, the root cause of the growing 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
October 11, 2010 at 7:35 am
jpSQLDude (10/11/2010)
1. I am pretty sure that when you perform a FULL backup, that never truncates the Transaction Log.
It doesn't, however....
In simple recovery a checkpoint truncates the log.
A backup runs...
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
October 11, 2010 at 7:30 am
By doing that you've also broken the log chain and left the system open to data loss.
After switching to simple recovery and back to full you will not longer 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
October 11, 2010 at 7:18 am
harag (10/11/2010)
If you...
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
October 11, 2010 at 5:38 am
shri.rapala (10/11/2010)
Use databasenamebackup log database with truncate_only
dbcc shrinkfile(logfilename) -----> sp_helpdb dbname
No, no, no!
Absolutely terrible advice to be giving, especially without any mention of what those command do.
Please read...
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
October 11, 2010 at 5:17 am
Viewing 15 posts - 30,046 through 30,060 (of 49,552 total)