Viewing 15 posts - 61 through 75 (of 119 total)
Here's a more thourough example of using the FileSystemObject (IMO)...
/******************************************************************************
** © Raylev Database Support & Consulting, 2005.
** This script is provided as is, and it's effects are not liable
**for...
May 22, 2008 at 7:47 am
Gila Monster, do you use multiple backup files, and if so how many? Or do you seperate backup threads by filegroup backup?
Backup performance is always an interesting topic... ...
May 21, 2008 at 11:50 am
Defragging disk on SAN's is really not neccessary due to the way disk/storage is allocated from the SAN to host.
This type of error is either network related or SAN related....
May 15, 2008 at 4:32 pm
It _should_ complete in around twenty minutes. However, there are far to many variables to take into consideration for a hard number...
Network speed (for either backup copy or network...
May 15, 2008 at 4:17 pm
Check to see if your account owns a 'duplicate' object..
dbo.Foo
YourAcct.Foo
May 14, 2008 at 12:48 pm
Yes, you're fine.
A full backup does not mess up the LSN chaining.
May 14, 2008 at 12:46 pm
If you're going to (or have to) use the 'sa' account, you should know what the password is/was....I don't know if a random sa password process would pass a SOX...
May 14, 2008 at 12:34 pm
MD (5/14/2008)
John is correct, this can be done without the use of backup devices.
To add...
If you're using a device, the performance of the backup job (not the backup...
May 14, 2008 at 11:59 am
Several years ago I wrote a process for this...
1: I used a "master" server that had all of the target servers as Linked Servers.
2: A procedure queried tested...
May 13, 2008 at 4:17 pm
Nicole (5/12/2008)
May 12, 2008 at 9:24 pm
Why not use a variable as a returncode?
DECLARE @iReturnCode int
EXEC @iReturnCode = EXEC dbo.my_RestoreSP
You'll get either a 0 or an error returned. This is what I do for my...
May 12, 2008 at 3:05 pm
Rootman (5/12/2008)
Although the 'boys and their toys' theory could be right. Many DBA's and other IT people I know ride motorbikes, and even have pictures...
May 12, 2008 at 3:01 pm
Yes, you can restore it from the network. You'll need to ensure a couple things first though:
1: SQLAgent on the dbserver is using a domain account.
2: The domain account...
May 12, 2008 at 2:00 pm
Unfortunatly, there isn't anything to do other than find/make the freespace.
If the original database used multiple files, you have the option of restoring them to different physical drives.
May 12, 2008 at 1:47 pm
The backup file size is relevant only to the amount of data stored, not the amount of storage allocated to the databse.
You can have a 10MB backup file that restores...
May 12, 2008 at 1:14 pm
Viewing 15 posts - 61 through 75 (of 119 total)