What are the ONLY files I need to backup from SQL SERVER 1

[nate2345]

Hi Guys,

I have Sql server running on my computer (it's for an application that I'm using) and I need to find out what are the ONLY files that I need to backup inorder to beable to restore the database on another computer if necessary.

I know that the data folder is necessary (is everything in there integral?). But do I need anything else from any other folder?

Any help would be appreciated since I'm not very familiar with sql server.

Thanks,
Nate

 

[mrdenny]

The files within the data folder are the database.

Backing them up while the SQL Server is running won't do you any good. You can't backup the database files while SQL is running because SQL Server locks the files open while it's running.

To backup the files directly you would need to stop the SQL Service, then backup the files.

You should do backups from within SQL Server then move those files off site.

The important things to backup are the databases and any extended stored procedures you have added. You'll also want to make not of any settings you have changed.

Everything else will get put in when you install SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[nate2345]

Where are extended stored procedures usually found (which folder)?

 

[mrdenny]

They can be anywhere. Typically they would be in "c:\Program Files\Microsoft SQL Server\MSSQL\binn\". You would know if any where added, it's not done often.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[nate2345]

Thanks for your help.

Nate