Viewing 15 posts - 4,246 through 4,260 (of 6,676 total)
I would be concerned about opening/closing a connection every 15 seconds. If you are using connection pooling and/or not actually closing the connection, then not much to worry about....
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
January 14, 2010 at 3:44 pm
GilaMonster (1/14/2010)
Are you using differential backups? If not, there's no real reason to take copy-only backups.
Gail - the concern I would have here is that the OP is looking at...
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
January 14, 2010 at 3:42 pm
Here is one of the better scripts available for perform a smart reindex: http://sqlfool.com/tag/indexes/
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
January 14, 2010 at 3:33 pm
Dugi (1/14/2010)
Copy Only Backup with SSMS are supported just in SQL Server 2008!
Wrong - COPY_ONLY is not available when using the GUI in SSMS 2005, however - you can still...
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
January 14, 2010 at 1:50 pm
Dugi (1/14/2010)
You should create PowerShell script that will stop the SQL Server services, copy files from folder to other folder,...
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
January 14, 2010 at 1:45 pm
You want to lookup Ranking Functions in Books Online and probably use ROW_NUMBER() to get the results you are looking for.
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
January 14, 2010 at 1:38 pm
And, do not upgrade your existing instance or tools. They will work side-by-side with no problems at all. If you have to support any 2005 instances at all...
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
January 14, 2010 at 1:35 pm
Lynn Pettis (1/14/2010)
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
January 14, 2010 at 1:31 pm
You cannot use a 32-bit driver from a linked server. The linked server process is running in x64 - which means you have to use x64 drivers.
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
January 14, 2010 at 1:25 pm
No - changing from FULL to BULK-LOGGED and back again does not break the log chain. Changing to/from SIMPLE breaks the log chain.
See the article I link to in...
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
January 13, 2010 at 4:05 pm
I don't know of any way to do what you want by directly calling the procedure. You can create a report in SSRS that will render on multiple sheets,...
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
January 13, 2010 at 3:52 pm
That is normal behavior - and yes, the data you are accessing is not in the data buffer and has to be loaded. Once loaded, your queries will get...
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
January 13, 2010 at 3:39 pm
GSquared (1/13/2010)
Does RedGate's backup product use the SQL backup engine? I don't see...
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
January 13, 2010 at 2:32 pm
Daily differential and weekly fulls of what drive? No need to try and backup your data or log volumes since the database files won't be backed up anyways.
With this...
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
January 13, 2010 at 2:15 pm
I really don't understand your question - sorry.
Why would someone have access to the server and be able to change/modify SQL Server files? The files SQL Server needs to...
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
January 13, 2010 at 2:03 pm
Viewing 15 posts - 4,246 through 4,260 (of 6,676 total)