Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.

RE: CREATING A BACKUP COPY OF A DATABASE IN SQL SERVER

 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Leonard Trevor
  Where is Leonard Trevor?
 Edinburgh
 United Kingdom
 Leonard Trevor
Subject: RE: Creating a backup copy of a database in SQL Server
Thread ID: 104154 Message ID: 104228 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Sunday, August 13, 2006 3:49:03 PM         
   


> What is the process required to make a backup copy of a database in sql server into a different directory or a replica on the same computer.?

The BACKUP command will do this (and a lot more) for you. See SQL Server Books Online Topic:
"Backing Up and Restoring Databases"

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA

ENTIRE THREAD

Creating a backup copy of a database in SQL Server Posted by Leonard Trevor @ 8/12/2006 7:34:30 AM
RE: Creating a backup copy of a database in SQL Server Posted by Ken Murphy @ 8/12/2006 2:56:03 PM
RE: Creating a backup copy of a database in SQL Server Posted by Leonard Trevor @ 8/12/2006 4:58:10 PM
RE: Creating a backup copy of a database in SQL Server Posted by Hans de Groot @ 8/13/2006 2:38:21 PM
RE: Creating a backup copy of a database in SQL Server Posted by Noker Lodia @ 8/14/2006 12:16:33 AM
RE: Creating a backup copy of a database in SQL Server Posted by Andy Kramek @ 8/13/2006 3:49:03 PM