Viewing 15 posts - 45,661 through 45,675 (of 49,552 total)
Abhijit (7/16/2008)
Can we perform the restoration strategy this below manner..
1 Full say full1, full2
2 Differential say diff1, diff2, diff3....
3 Transaction say trn1, trn2....
When restoring the database.. Suppose u have...
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
July 16, 2008 at 1:00 am
matt stockham (7/15/2008)
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
July 16, 2008 at 12:45 am
Marios Philippopoulos (7/15/2008)
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
July 16, 2008 at 12:41 am
Roust_m (7/15/2008)
But apparantly it does not allow you to share a production database (read/write) with reporting servers in read only mode.
You are correct, it does not. All of the databases...
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
July 16, 2008 at 12:40 am
rinu philip (7/15/2008)
The result gave : dataname,FULL,LOG_BACKUPIn the query : SELECT name, recovery_model_desc, log_reuse_wait_desc from sys.databases
what does 'log_reuse_wait_desc' --mean?
Its the reason that the space in the log file is...
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
July 16, 2008 at 12:34 am
SQL King (7/15/2008)
Well, i guess I have to stick with the old plan where I have Full Backup and full recovery. But I am definately taking 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
July 16, 2008 at 12:29 am
Abhijit (7/15/2008)
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
July 16, 2008 at 12:24 am
Transaction log entries are only purged on checkpoint if you are running in simple recovery mode. If you are in simple recovery mode, you cannot run log backups at all.
In...
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
July 15, 2008 at 12:51 pm
SQL King (7/15/2008)
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
July 15, 2008 at 12:47 pm
What do you get returned by the following (fix directory and server names if necessary)
exec master..xp_cmdshell 'dir \\Server 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
July 15, 2008 at 12:34 pm
GSquared (7/15/2008)
This Solomon name on each table looks very familiar. Did I do something else with this database a while back?
Probably. This isn't the first time Mike's posted 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
July 15, 2008 at 12:27 pm
Any Advice on Tuning
Yeah. Get rid of the cursor. I can't see anything that makes the cursor necessary.
Some information on what it's supposed to do, structures of tables involved and...
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
July 15, 2008 at 12:24 pm
steve smith (7/15/2008)
I can't get this to load in my browser. Is there a problem in the way it's cited?
Try doing a save-as
I've greatly enjoyed this thread, and 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
July 15, 2008 at 12:13 pm
Jonathan Kehayias (7/15/2008)
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
July 15, 2008 at 12:02 pm
Do you have replication active?
Do you have database mirroring?
If you run the following, what does it return for the DB in question?
SELECT name, recovery_model_desc, log_reuse_wait_desc from sys.databases
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
July 15, 2008 at 11:25 am
Viewing 15 posts - 45,661 through 45,675 (of 49,552 total)