Viewing 15 posts - 4,456 through 4,470 (of 6,676 total)
And, only if you have a current backup. Until the database is backed up for the first time - the transaction log is in a psuedo-simple mode where it...
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 20, 2009 at 2:54 pm
jrw39 (10/20/2009)
GSquaredthanks, one more question what does the CTE represent?
CTE is Common Table Expression. You can look it up in Books Online for further information, but generally it can...
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 20, 2009 at 2:46 pm
Review the SSIS packages - on the OLEDB destination you want to validate that you have set a batch size and a commit size. Setting these should help reduce...
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 20, 2009 at 2:37 pm
I would look at using Hyperbac myself. Or, you could look at the various products available from Redgate, Quest, Idera, etc... that perform backups and allow for compression.
Using Litespeed,...
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 20, 2009 at 1:40 pm
Chuoi Tieu (10/20/2009)
Fantastic. Thank you very much. I get it working now. I use REVOKE instead and it works fine.Thanks,
There is absolutely no reason to do anything in Public. ...
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 20, 2009 at 1:19 pm
peterzeke (10/20/2009)
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 20, 2009 at 1:15 pm
If you were not done - then you have to start the restore over.
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 20, 2009 at 1:10 pm
repent_kog_is_near (10/20/2009)
Thanks for the points. I have never used mirror before. Do I need one extra server to host the mirror?
Would there be benefits to doing DB snapshop instead 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
October 20, 2009 at 12:13 pm
Dan,
For item 1 - yes, those are the technologies I was talking about. And, no - you would not be hitting the original (production) system because the database snapshot...
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 20, 2009 at 9:49 am
You probably are running in a parameter sniffing issue - review the following article by Gail (follow the links for the other articles also): http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/
You can also verify the connection...
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 19, 2009 at 2:31 pm
Jeff - without knowing which SAN it was, it's hard to say what is actually possible. For example, I have two types of SAN's available. Netapp and HP...
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 18, 2009 at 10:57 am
If you are running Enterprise Edition on your reporting server, you can create a database mirror and a database snapshot off of the mirrored database.
Perform the db snapshot every 4/6/8...
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 18, 2009 at 10:24 am
homebrew01 (10/16/2009)
ItalianOlgi (10/16/2009)
Hello,I have question:
What is index fragmentation? Why is important to keep it at or below 20%?
Indexes should be below 10%. Once they reach 10%, they are now using...
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 16, 2009 at 11:54 pm
GSquared (10/16/2009)
ItalianOlgi (10/16/2009)
Hello,I have question:
What is index fragmentation? Why is important to keep it at or below 20%?
Because it tastes better that way.
(Others reading this thread, be aware that 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
October 16, 2009 at 7:52 pm
SQL Server 2008 no longer includes the group BUILTIN\Administrators, and does not automatically make members of that group sysadmins.
Also, on Windows Server 2008, Vista and Windows 7 - you 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
October 16, 2009 at 5:26 pm
Viewing 15 posts - 4,456 through 4,470 (of 6,676 total)