Viewing 15 posts - 3,601 through 3,615 (of 6,679 total)
Because you are running Standard Edition on SP2 - you do not have the advantage of using locked pages in memory.
You'll need to set even lower max memory than 16GB...
September 6, 2010 at 7:05 pm
Well, I don't know what to tell you - are you creating those backup files from a different system/instance? Could you be creating those backups with a non-native backup...
September 6, 2010 at 3:10 pm
mak101 (9/6/2010)
How can I open stored package from management studio?
You cannot open SSIS packages in SSMS - you have to use BIDS to open the packages and work with them.
Within...
September 6, 2010 at 12:15 pm
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...
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...
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...
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 ...
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...
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,...
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...
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...
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.
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.
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...
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...
September 5, 2010 at 2:12 pm
Viewing 15 posts - 3,601 through 3,615 (of 6,679 total)