Viewing 15 posts - 3,601 through 3,615 (of 6,676 total)
mak101 (9/6/2010)
WayneS (9/6/2010)
mak101 (9/6/2010)
Thank you found it.Another question- How do I keep same identity value from original table?
On that same screen (Column Mappings) is a check box for "Enable...
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 6, 2010 at 11:50 am
WayneS (9/6/2010)
mak101 (9/6/2010)
And I saved it as SSIS package on the server. But I don't find the way to open it. Can you please help?Thanks.
Open up BIDS. Start a new...
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 6, 2010 at 11:48 am
Before you try to shrink the file - you need to identify why it grew that large in the first place. If it grew that way because it was...
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 6, 2010 at 11:44 am
SKYBVI (9/6/2010)
The exact location of the bak file is :-
\\server_name\D:\ABC(shared)\Priya(shared)\db_name.bak
in back up task, I' mentioned \\server_name\Priya ...
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 6, 2010 at 11:39 am
Not sure what you are asking, but if you want a stored procedure to start multiple packages so they all run at the same time, then the easiest way is...
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 6, 2010 at 10:51 am
As stated previously, you need to follow up with your SAN engineers. The documentation for the snapshot utility being used should document how it works with SQL Server.
If not,...
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 6, 2010 at 10:48 am
SKYBVI (9/6/2010)
@ jeffreyEXECUTE master.dbo.xp_delete_file 0,N'\\server_name\Priya',N'bak',N'09/05/2010 12:21:24'
Regards,
Sushant
The only thing I see wrong with the above command is that it is missing the option to include first-level subfolders. If your backups...
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 6, 2010 at 10:45 am
What is the data type of your duedate column? If it is a datetime - are the dates always at midnight, or will they have a time?
Most likely, 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 6, 2010 at 10:32 am
Yes - you can do that. Are you having a problem setting it up? If so, post the error you are getting.
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 6, 2010 at 10:16 am
Open up the task and click the button to view the SQL - copy/paste that back here so we can see how it is setup.
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 6, 2010 at 10:08 am
SKYBVI (9/6/2010)
The two tasks r connected such as ... if the backup succeeds then the maintenenace plan should clean up older files.
The directory in maintenenace plan is the same as...
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 6, 2010 at 10:07 am
You don't buy a license for x64 or x86 - you buy licenses by CAL or by processor. If you purchase processor licenses, then you can install as many...
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 5, 2010 at 2:12 pm
magasvs (9/5/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
September 5, 2010 at 2:01 pm
Again, a differential is based upon the previous full backup taken prior to the differential. Once you performed the snapshot backup (which is a full backup), then your differential...
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 4, 2010 at 2:59 pm
Snapshot backups are not a part of SQL Server. They are SAN functionality. The SAN uses VDI to freeze SQL and tell SQL a backup has been performed.
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 3, 2010 at 10:13 pm
Viewing 15 posts - 3,601 through 3,615 (of 6,676 total)