Viewing 15 posts - 6,046 through 6,060 (of 6,676 total)
You can find references to incremental backups for SQL Server in the SMO documentation. From there, an incremental backup is equivelant to a differential backup in SQL Server.
Using SMO...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 2, 2008 at 2:20 pm
rbarryyoung (9/30/2008)
Yeah, if I do have to do this, I would much rather use OPENQUERY than xp_CmdShell.
I have to agree with this - especially since you cannot be assured that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 30, 2008 at 1:48 pm
rbarryyoung (9/30/2008)
Wouldn't you want to do it like this?:
SELECT *
FROM table1
LEFT JOIN (table2 INNER JOIN table3 ON table3.fkey = table2.Pkey)
ON table2.fkey = table1.Pkey
Absolutely,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 30, 2008 at 1:36 pm
tbeadle (9/29/2008)
While it's true the "non-standard' outer joins are depreciated, they do work and will work quite some time into the future. Microsoft depreciated announcements do not mean the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 30, 2008 at 12:24 pm
tbeadle,
Your recommended solution will not work because it is using non-ANSI outer join operators. Those operators have been deprecated in SQL Server 2005.
To the OP - the other solutions...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 26, 2008 at 5:46 pm
Deleting data from the database will not shrink the database file size. What you are seeing is correct and is what I would expect.
BTW - you want to have...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 26, 2008 at 5:37 pm
You are still going to use CONVERT - but, you need to tell it what style. Look up CONVERT in Books Online for the correct style to return just...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 26, 2008 at 2:41 pm
Yeah - that's what I think also, based upon the original post. Still, have to wonder why someone would run 12 instances on a system with only 4GB of...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 26, 2008 at 2:14 pm
Glad I could help
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2008 at 7:27 pm
Unfortunately, I only have SQL Server 2008 installed on this workstation - so the link I have would not work for you.
If you open Books Online (or, from SSMS go...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2008 at 5:17 pm
Try defining an operator that only receives notifications using net send. Then, use sp_notify_operator to send a notification to that operator.
I haven't tested it myself - but, it should...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2008 at 5:13 pm
If you don't want to look at clustering - consider Database Mirroring instead. You could replace your log shipped database with a mirror, setup a witness for failover and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2008 at 4:07 pm
You should rebuild your indexes as often as needed. I don't know your system or how often your indexes are becoming fragmented - so, I really couldn't say whether...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2008 at 4:01 pm
The right order really depends upon your business requirements, the disaster recovery requirements and system restore requirements. My preferences is to perform the backups last, that way I don't...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2008 at 3:31 pm
GSquared (9/24/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 24, 2008 at 3:22 pm
Viewing 15 posts - 6,046 through 6,060 (of 6,676 total)