Viewing 15 posts - 3,556 through 3,570 (of 6,676 total)
chris.s.powell (10/13/2010)
Why not create a seperate Maintenance Plan for each Db?
Because then you don't have control over the sequencing of the backups. However, you could create separate maintenance plans...
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 13, 2010 at 2:27 pm
If you are looking to speed up the transfer of the compressed file, then your options are limited. If you can get away from FTP, you could use a...
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 13, 2010 at 2:20 pm
Backing up across the network is much more open to failure. If there are any issues with the network, your backups will fail. Additionally, there are configuration settings...
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 12, 2010 at 8:14 pm
You really shouldn't use a percentage for auto-growth, on either the data or log files. You don't really want that to ever happen, but if it does - you...
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 11, 2010 at 1:41 pm
Apparently, you can use this on a full backup also. This can be used when migrating a database to a new server.
Perform the full backup with norecovery - 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
October 9, 2010 at 10:42 am
Read the article in my signature on Managing Transaction Logs. You cannot move data in the log files the way you are trying to, you have to perform transaction...
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 9, 2010 at 10:39 am
Shawn, yes - I didn't see that. Thanks.
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 8, 2010 at 1:34 pm
The recommended method is now:
1) Alter Database {db} Modify File (Name = logical_name, filename = 'new pathame');
2) Alter Database {db} Set Offline With rollback immediate;
3) Copy files to new location
4)...
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 7, 2010 at 4:26 pm
First, you need to identify how a user is associated to a particular group. Looking at the data, there is no way to tell that User2 belongs to Group1....
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 6, 2010 at 2:41 pm
Ken Klaft-381933 (10/6/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
October 6, 2010 at 2:34 pm
Okay, I want to make sure I am understanding here.
Did you use SSMS to create the maintenance plan?
Did you use the maintenance plan schedule to schedule and create the agent...
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 6, 2010 at 10:20 am
Okay - how was the agent job created? Did you create the agent job manually, or did you setup the schedule in the maintenance plan and set it up...
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 4, 2010 at 1:40 pm
Try removing the begin tran and commit tran - every time you run your update, the same rows are selected because the update hasn't actually committed the changes yet.
If you...
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 3, 2010 at 7:05 pm
Verify the connection string for the maintenance plan - do you have another instance of SQL Server that this plan could be accessing and running the backups on?
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 28, 2010 at 7:46 pm
Jpotucek (9/26/2010)
I did take a full backup after and I will defrag the indexes.. Thank you : )any suggestions for getting the backups any smaller ?
Use...
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, 2010 at 6:21 pm
Viewing 15 posts - 3,556 through 3,570 (of 6,676 total)