Ask The SQL Server Expert: Questions & Answers
Archive: Backup and Recovery
With Edgewood Solutions founder Greg Robidoux.
-
Back up tables from SQL Server 2005 database to a file
Ask the Expert - Back up tables from a SQL Server database to a file with these commands. 26 September 2007 -
Restore SQL Server 2000 backups in SQL Server 2005
Ask the Expert - Restore backups in SQL Server 2000 and SQL Server 2005 with this command. 26 September 2007 -
Restoring a SQL Server database with a corrupt data file
Ask the Expert - Find out how to restore data from a corrupt database. 26 September 2007 -
Synchronize databases on two separate active servers
Ask the Expert - Synchronize databases on separate servers without using SANs. Learn options for server failover in SQL Server including log shipping, database mirroring and replication. 26 September 2007 -
SQL Server error message: "Server out of memory"
Ask the Expert - Avoid restoring your SQL Server database to solve the SQL Server error message "server out of memory." The problem could be the memory settings. 26 September 2007 -
Configure log shipping between SQL Server 2000 and 2005
Ask the Expert - Have you upgraded to SQL Server 2005 and need to configure log shipping between SQL Server 2000 and SQL Server 2005? Learn about that possibility. 17 September 2007 -
Restoring from msdb with only .mdf and .ldf files
Ask the Expert - I am working on an issue with an undocumented application, and the info is/was on a SS7 database, that was not maintained properly.How can I restore jobs from msdb when all I have is either a backup of it (but don't want to restore it to another server's msdb) or no backup - just the .mdf and .ldf files? 30 March 2007
-
Extended stored procedure to back up databases
Ask the Expert - Does SQL Server 2005 (any edition) come with an extended stored procedure, allowing you to back up databases? If so, what is it called? I've looked all over the internet but only found third party ones. 26 March 2007 -
Change tempdb from 'C' drive
Ask the Expert - Is it possible to change tempdb from the 'C' drive, to any other drives? 23 March 2007 -
Back up stored procedure only
Ask the Expert - Is it possible to back up the stored procedure only? If so, how? 23 March 2007