Viewing 15 posts - 46 through 60 (of 345 total)
Jonathan.Sims (8/12/2008)
Great SP ScottBut i do have one question, every so often my msdb databases is skipped with this backup, have you (or anyone) ran into this issue before?
I've replied...
August 18, 2008 at 2:51 pm
JCasale (2/29/2008)
I receive Server: Msg 8145, Level 16, State 2, Procedure sp_purge_jobhistory, Line 0 @oldest_date is not a parameter for procedure sp_purge_jobhistory when trying to run the sproc. Being...
August 18, 2008 at 2:49 pm
amit hollenberg (1/17/2008)
it will be nicer if it will be wrapped in a cursor or some kind of a loop that will backup all the Database...
August 18, 2008 at 2:43 pm
Vee (7/8/2008)
Its a great script. We use this stored proc to loop through all the databases in another stored procedure.
I have used like this
SP_MSFOREACHDB 'EXECUTE DBO.USP_DBBackup ''full'',''?'',''E:\sqlbackups'',''1'',1'
My suggestion are.
1....
August 18, 2008 at 2:40 pm
tdepalo (3/28/2008)
Scott, this is a great backup sp. Would you happen to have a matching restore sp that will pick up the latest backup file?Thanks
Tom
No, but that's just because...
August 18, 2008 at 2:30 pm
You'll need to work with the NTFS permissions to restrict what files/folders their account has access to. I'd recommend creating an administrative account for them to use, rather than...
August 17, 2008 at 9:54 pm
As a side feature, HyperBac allows you to mount a SQL Server backup as a linked server (it is primarily a SQL Server backup compression/encryption tool). See
August 17, 2008 at 9:47 pm
As a side note, when getting SQL Surface Area Manager to connect to a clustered SQL Server, you have to change the computer name to the virtual SQL Server name...
August 17, 2008 at 9:34 pm
Ted Pin (8/14/2008)
GilaMonster (8/14/2008)
August 14, 2008 at 5:07 pm
Using SSMS you can script out all objects in a database. Right-click on the database, select Tasks then Generate Scripts. Set your options to include database creation and...
August 13, 2008 at 9:31 pm
Define "running slow". Are the disks grinding away, are users submitting queries and getting long wait times? Can you log on to the console without massive delays?
Start with...
August 13, 2008 at 7:48 pm
After you've run sp_dropserver, sp_addserver, you will need to restart SQL Server for the changes to take effect.
August 13, 2008 at 7:27 pm
My advice is to get over your idle curiosity as soon as possible! ...
I'm with Charles on this one.
At one job in the past, we were getting royally screwed by...
August 13, 2008 at 2:26 pm
Surely any schema changes would be going through QA first? Assuming software development lifecycle of DEV, TEST, QA, Production is being used. What's the lead time between schema...
August 12, 2008 at 9:54 pm
Steve beat me to it - I just thought of the same. If you restore the DB with standby, you can use bcp or probably SSIS to pull the...
August 11, 2008 at 10:12 pm
Viewing 15 posts - 46 through 60 (of 345 total)