Viewing 15 posts - 1 through 15 (of 181 total)
Based on your DB sizes, you can probably get it done over the wire.
Use Winrar to rar them up and send the full backups over the wire. Since 70GB is...
December 18, 2007 at 8:32 am
Great Content, cutting edge solutions, knowledgeable and helpfull members. Its a complete resource center for everything about SQL Server for advanced SQL Server users to novices.
October 2, 2007 at 12:27 pm
Best option is LogExplorer. Its easy and painless.
August 31, 2007 at 7:39 am
I would start by taking a full backup - restore it on the standby server and then follow that up with the transaction log from there.
August 31, 2007 at 7:37 am
Since tempdb is recreated when you re-start SQL services. If it is a devl server and you can afford to restart the service - stop...
August 21, 2007 at 11:38 am
Have you looked at http://www.freetds.org/
August 21, 2007 at 11:29 am
Shawn - thats what I thought, thanks for clarifying that.
yeah - I have left 500MB for the OS. Will run some more tests and see how things look
Have a good...
August 1, 2007 at 12:36 pm
Can someone please tell me if "lock pages in memory" is supported in SQL 2005 Standard, 64 bit. From from I can tell - it is not supported and even...
August 1, 2007 at 11:37 am
Its Microsoft we talking about
There are too many to list.
July 12, 2007 at 4:01 pm
Did you try executing the job manually to see if it completes?
July 12, 2007 at 3:58 pm
"You can't backup the database and tlogs at the same time. Your T-log backup will fail."
T-log backup will not fail - it will just wait till the full database...
October 10, 2006 at 4:13 pm
if you use hostname in the connection strings, than all you have to do is update DNS. Just make sure you identify all connection strings DSN's etc.
October 10, 2006 at 4:05 pm
Drop and recreate your DSN - test DSN connection when creating as well
September 18, 2006 at 8:32 am
not sure what you mean by requiring a hotfix to backup over the network. Talk to your network guys about setting up the required permissions for you to a server...
September 15, 2006 at 8:51 am
Did you try it dbcc log setting output to type=4 which will give you full information about each operation plus hexadecimal dump of the current transaction log's row.
But for...
September 15, 2006 at 8:43 am
Viewing 15 posts - 1 through 15 (of 181 total)