Backup procedure

Hello there!
I have SQLServer 2000 running on Windows 2000 advanced server.
I want to schedule daily full backup.
Do I have to stop SQLServer service before it starts backup?
Or can users have full access to the database while it's doing the backup?
Thanks in advanceRead the chapter on Backup and Restore in BOL (Books On-Line). This will
explain some of the unique considerations and options for backing up a SQL
server installation.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rexford" <anonymous@.discussions.microsoft.com> wrote in message
news:B5E24755-6290-44CD-9FC2-99309FB5C9D4@.microsoft.com...
> Hello there!
> I have SQLServer 2000 running on Windows 2000 advanced server.
> I want to schedule daily full backup.
> Do I have to stop SQLServer service before it starts backup?
> Or can users have full access to the database while it's doing the backup?
> Thanks in advance|||Hi,
It is not at all required to shutdown SQL server while doing a full database
backup. But try to perform the full database backup during the time zone
where user access is less.
Thanks
Hari
MCDBA
"Rexford" <anonymous@.discussions.microsoft.com> wrote in message
news:B5E24755-6290-44CD-9FC2-99309FB5C9D4@.microsoft.com...
> Hello there!
> I have SQLServer 2000 running on Windows 2000 advanced server.
> I want to schedule daily full backup.
> Do I have to stop SQLServer service before it starts backup?
> Or can users have full access to the database while it's doing the backup?
> Thanks in advance

Backup MS SQL 2005 -> Restore MS SQL 2000

hi there

i've made a backup from a MS SQL Server 2005 database and i tried to restore this database to a MS SQL Server 2000. Unfortunately, I got following error

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrad this database.

what can i do ? is it possible to restore the MS SQL Server 2005 DB on a MS SQL Server 2000 ?

PhilippNo, the file formats are not backwards compatible. You would need to do some type of logical copy of your data via BULK INSERT and scripts to create the tables.|||

Check out the Database Publishing Wizard: http://www.codeplex.com/sqlhost

I will create a script a database that includes inserts for all the data.

|||

I faced the same situation many times.

The easiest method is to just create an empty database on SQL Server 2000 and use the Export Data wizard from SQL Server 2005 Management Studio to copy your tables and views. For stored procedures you need to create scripts on 2005 and run it on 2000.

Backup Microsoft SQL 6.0

Hi there

I have a old MS SQL 6.0 Server. I wanted to do a full backup and migrate to MS SQL Express!
My objective for now is to find guides on how to backup MS SQL 6.0. Anyone can enlighten me as I can't find a guide/tips on this area.

MS SQL
Version: 6.0.0.121

Many thanks.

Regards,
makan007

Wow - interesting. To get to SQL Express you need to come from no earlier than 7.0 - upgrade from 7.0 to 9.0 (SQL Server 2005) is the most backward-looking upgrade path that's supported. I discussed how to get to 7.0 with my wife Kimberly Tripp, as it's before my time, and she advises installing 7.0 and then using the migration wizard from 6.0 to 7.0 - if that's supported. One issue you have is that nothing that old is supported at all, so if you run into any issues you'll have a hard time finding support. I know some people in Product Support who were around then - let me know if you hit any problems and I may be able to to get you some limited help.

|||What I meant was I am going to restore my SQL 6.0 data to another server (w/ MS SQL Express). Will there be any issue?
|||

Yes - you can't directly attach/restore a 6.0 database to a 2005 server without first upgrading it to 7.0 as there's a big conversion that has to take place between 6.5 and 7.0.

Thanks

Backup Microsoft SQL 6.0

Hi there

I have a old MS SQL 6.0 Server. I wanted to do a full backup and migrate to MS SQL Express!
My objective for now is to find guides on how to backup MS SQL 6.0. Anyone can enlighten me as I can't find a guide/tips on this area.

MS SQL
Version: 6.0.0.121

Many thanks.

Regards,
makan007

Wow - interesting. To get to SQL Express you need to come from no earlier than 7.0 - upgrade from 7.0 to 9.0 (SQL Server 2005) is the most backward-looking upgrade path that's supported. I discussed how to get to 7.0 with my wife Kimberly Tripp, as it's before my time, and she advises installing 7.0 and then using the migration wizard from 6.0 to 7.0 - if that's supported. One issue you have is that nothing that old is supported at all, so if you run into any issues you'll have a hard time finding support. I know some people in Product Support who were around then - let me know if you hit any problems and I may be able to to get you some limited help.

|||What I meant was I am going to restore my SQL 6.0 data to another server (w/ MS SQL Express). Will there be any issue?
|||

Yes - you can't directly attach/restore a 6.0 database to a 2005 server without first upgrading it to 7.0 as there's a big conversion that has to take place between 6.5 and 7.0.

Thanks