keeping all the data in sync is also a huge amount of overhead.

Without knowing exactly what your program does and what expantion limitations you have hit on now its hard...

there is a real possibility that you may have lost data. if there were transactions in the log that had not been commited to the datafile they are now gone....

check permissions on the sql server service if it is backing up locally local system should be fine. if you are backing up to a network share make sure the...

sql server 2000 doesn't allow a tlog backup during a full. 2005 allows you to continue to do tlog backups during the full.

shipping a database to another site without breaking the backup chain locally. SQL Server 2005 supports the "one off" kind of backup but 2000 doesn't.

Wes

The user that owns the database doesn't exist on your test system. You can create that user and restore or detach reattach and sql should remap the user that now...

the domain account that starts and stops sql server service can be a regular domain account but must have access to all the sql server directories. I generally setup the...

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1158 --user permissions

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1159 --user passwords

SELECT INTO #TEMPTABLE is treated just like a bulk insert.

Minimally logged operations (bulk load operations)

Data movement operations that require minimal logging in the transaction log. These operations include bcp,...

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1158

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1159

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=515

Last one may be what you are looking for with some minor modifications!

Wes

SQL DMO is a good way to go.

Do a search the the scripts here you should find one that uses DMO to script out almost any object you want....

I've go more insight than you would ever want to know! Do you have any specific questions?

I use imaging that supports sql server, and that is the key, to backup test machines all the time to get the whole system back to a specific state.

For...

Other than the hardware setup you really need to fit your backup schedule to what the business tells you it can withstand as far as data loss and/or down time....

Need license to restore on another server

LiteSpeed never requires a lic to restore. We won't hold your data hostage. You can use the extractor, or install the demo and...