Restore database...schedule

SQL Server Enterprise Edition
Microsoft Windows NT - 5.2 (3790)
Product version 8.00.760 (SP3)
1. I am moving two databases to different location (Both ldf and mdf files
because of size) on the same server. Can I automate the process and schedule
to run it at midnight. When I try to create a restore task using enterprise
manager it does not give me a option to schedule the task.
2. While performing same task(restore), few services on another server (Non
sql server) needs to be stopped, once restore is complete needs to be started
again. How to automate (start and stop services).
--
ontario, canadaProbably better to detach the database(s), move the files, thn re-attach
Check out sp_detach_db and sp_attach_db in Books Online. You can write a
few simple T-SQL statements and schedule these as a SQL job for the Agent to
run
Step 1 - sp_detach...etc.
Step 2 - xp_cmdshell 'copy the files...'
Step 3 - sp_attach_db
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"db" <db@.discussions.microsoft.com> wrote in message
news:63CA1294-582D-47BF-9508-65E44EDF74C6@.microsoft.com...
> SQL Server Enterprise Edition
> Microsoft Windows NT - 5.2 (3790)
> Product version 8.00.760 (SP3)
> 1. I am moving two databases to different location (Both ldf and mdf files
> because of size) on the same server. Can I automate the process and
> schedule
> to run it at midnight. When I try to create a restore task using
> enterprise
> manager it does not give me a option to schedule the task.
> 2. While performing same task(restore), few services on another server
> (Non
> sql server) needs to be stopped, once restore is complete needs to be
> started
> again. How to automate (start and stop services).
> --
> ontario, canada|||Can I schedule database restore. I have schedules non sql services to stop
at desired time.
--
ontario, canada
"Kevin3NF" wrote:
> Probably better to detach the database(s), move the files, thn re-attach
> Check out sp_detach_db and sp_attach_db in Books Online. You can write a
> few simple T-SQL statements and schedule these as a SQL job for the Agent to
> run
> Step 1 - sp_detach...etc.
> Step 2 - xp_cmdshell 'copy the files...'
> Step 3 - sp_attach_db
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:63CA1294-582D-47BF-9508-65E44EDF74C6@.microsoft.com...
> >
> > SQL Server Enterprise Edition
> > Microsoft Windows NT - 5.2 (3790)
> > Product version 8.00.760 (SP3)
> >
> > 1. I am moving two databases to different location (Both ldf and mdf files
> > because of size) on the same server. Can I automate the process and
> > schedule
> > to run it at midnight. When I try to create a restore task using
> > enterprise
> > manager it does not give me a option to schedule the task.
> >
> > 2. While performing same task(restore), few services on another server
> > (Non
> > sql server) needs to be stopped, once restore is complete needs to be
> > started
> > again. How to automate (start and stop services).
> > --
> > ontario, canada
>
>|||You can. Create a job with a RESTORE Database statement in it...
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"db" <db@.discussions.microsoft.com> wrote in message
news:4B5A046B-5A3F-4FB7-8FED-D4319B59DF81@.microsoft.com...
> Can I schedule database restore. I have schedules non sql services to
> stop
> at desired time.
> --
> ontario, canada
>
> "Kevin3NF" wrote:
>> Probably better to detach the database(s), move the files, thn re-attach
>> Check out sp_detach_db and sp_attach_db in Books Online. You can write a
>> few simple T-SQL statements and schedule these as a SQL job for the Agent
>> to
>> run
>> Step 1 - sp_detach...etc.
>> Step 2 - xp_cmdshell 'copy the files...'
>> Step 3 - sp_attach_db
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>> "db" <db@.discussions.microsoft.com> wrote in message
>> news:63CA1294-582D-47BF-9508-65E44EDF74C6@.microsoft.com...
>> >
>> > SQL Server Enterprise Edition
>> > Microsoft Windows NT - 5.2 (3790)
>> > Product version 8.00.760 (SP3)
>> >
>> > 1. I am moving two databases to different location (Both ldf and mdf
>> > files
>> > because of size) on the same server. Can I automate the process and
>> > schedule
>> > to run it at midnight. When I try to create a restore task using
>> > enterprise
>> > manager it does not give me a option to schedule the task.
>> >
>> > 2. While performing same task(restore), few services on another server
>> > (Non
>> > sql server) needs to be stopped, once restore is complete needs to be
>> > started
>> > again. How to automate (start and stop services).
>> > --
>> > ontario, canada
>>

restore database from CTP edition to developer edition

hi there,
i m currently using visual studio 2005 beta 2 with SQL server 2005 Developer Edition CTP developing application. i now considering to switch my project to use visual studio 2005 professional edition and SQL server 2005 Developer edition. however i was afraid that my database cannot be restore into SQL server 2005 Developer edition
anyway, can it be restore if i switch?

This worked for me, I backuped and restored the database from the CTP relase to the RTM developer edition.

HTH, Jens Suessmeyer.

Restore Completes (Loading)

I have SQL Server 2000 Enterprise Edition with SP3A on my
Windows 2000 Advanced Server. There is only one
development database on this server.
When I restore a backup from this database onto another
server in a similiar environment the restore completes.
But database icon status, states that it is loading. I
refresh the databases (PF5) but it does not change.
Next, I run the restore database with recovery and the
restore completes.
Please help me resolve this issue.
Mike
RESTORE DATABASE DATABASE_NAME
from disk =
WITH RECOVERY
Are you sure that the environment is the same, or that there are no pending
transactions? According to BOL, the WITH RECOVERY option IS the default
option, and should only be required when a database upgrade is required.
Steve
RECOVERY
Instructs the restore operation to roll back any uncommitted transactions.
After the recovery process, the database is ready for use.
If subsequent RESTORE operations (RESTORE LOG, or RESTORE DATABASE from
differential) are planned, NORECOVERY or STANDBY should be specified
instead.
If neither NORECOVERY, RECOVERY, or STANDBY is specified, RECOVERY is the
default. When restoring backup sets from an earlier version of SQL Server, a
database upgrade may be required. This upgrade is performed automatically
when WITH RECOVERY is specified. For more information, see Transaction Log
Backups .
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1deb101c4548a$985d2e00$a401280a@.phx.gbl...

> I have SQL Server 2000 Enterprise Edition with SP3A on my
> Windows 2000 Advanced Server. There is only one
> development database on this server.
> When I restore a backup from this database onto another
> server in a similiar environment the restore completes.
> But database icon status, states that it is loading. I
> refresh the databases (PF5) but it does not change.
> Next, I run the restore database with recovery and the
> restore completes.
> Please help me resolve this issue.
> Mike
>
> RESTORE DATABASE DATABASE_NAME
> from disk =
> WITH RECOVERY
>
|||HI,
It seems you have clicked the option "Non operational, need to load more
transaction logs" in enterprise manager while loading. Execute the below
command from query analyzer to recover the database:-
RESTORE DATABASE <dbname> with RECOVERY
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1deb101c4548a$985d2e00$a401280a@.phx.gbl...
> I have SQL Server 2000 Enterprise Edition with SP3A on my
> Windows 2000 Advanced Server. There is only one
> development database on this server.
> When I restore a backup from this database onto another
> server in a similiar environment the restore completes.
> But database icon status, states that it is loading. I
> refresh the databases (PF5) but it does not change.
> Next, I run the restore database with recovery and the
> restore completes.
> Please help me resolve this issue.
> Mike
>
> RESTORE DATABASE DATABASE_NAME
> from disk =
> WITH RECOVERY
>

Restore Completes (Loading)

I have SQL Server 2000 Enterprise Edition with SP3A on my
Windows 2000 Advanced Server. There is only one
development database on this server.
When I restore a backup from this database onto another
server in a similiar environment the restore completes.
But database icon status, states that it is loading. I
refresh the databases (PF5) but it does not change.
Next, I run the restore database with recovery and the
restore completes.
Please help me resolve this issue.
Mike
RESTORE DATABASE DATABASE_NAME
from disk =
WITH RECOVERYAre you sure that the environment is the same, or that there are no pending
transactions? According to BOL, the WITH RECOVERY option IS the default
option, and should only be required when a database upgrade is required.
Steve
RECOVERY
Instructs the restore operation to roll back any uncommitted transactions.
After the recovery process, the database is ready for use.
If subsequent RESTORE operations (RESTORE LOG, or RESTORE DATABASE from
differential) are planned, NORECOVERY or STANDBY should be specified
instead.
If neither NORECOVERY, RECOVERY, or STANDBY is specified, RECOVERY is the
default. When restoring backup sets from an earlier version of SQL Server, a
database upgrade may be required. This upgrade is performed automatically
when WITH RECOVERY is specified. For more information, see Transaction Log
Backups .
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1deb101c4548a$985d2e00$a401280a@.phx
.gbl...

> I have SQL Server 2000 Enterprise Edition with SP3A on my
> Windows 2000 Advanced Server. There is only one
> development database on this server.
> When I restore a backup from this database onto another
> server in a similiar environment the restore completes.
> But database icon status, states that it is loading. I
> refresh the databases (PF5) but it does not change.
> Next, I run the restore database with recovery and the
> restore completes.
> Please help me resolve this issue.
> Mike
>
> RESTORE DATABASE DATABASE_NAME
> from disk =
> WITH RECOVERY
>|||HI,
It seems you have clicked the option "Non operational, need to load more
transaction logs" in enterprise manager while loading. Execute the below
command from query analyzer to recover the database:-
RESTORE DATABASE <dbname> with RECOVERY
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1deb101c4548a$985d2e00$a401280a@.phx
.gbl...
> I have SQL Server 2000 Enterprise Edition with SP3A on my
> Windows 2000 Advanced Server. There is only one
> development database on this server.
> When I restore a backup from this database onto another
> server in a similiar environment the restore completes.
> But database icon status, states that it is loading. I
> refresh the databases (PF5) but it does not change.
> Next, I run the restore database with recovery and the
> restore completes.
> Please help me resolve this issue.
> Mike
>
> RESTORE DATABASE DATABASE_NAME
> from disk =
> WITH RECOVERY
>

Restore Completes (Loading)

I have SQL Server 2000 Enterprise Edition with SP3A on my
Windows 2000 Advanced Server. There is only one
development database on this server.
When I restore a backup from this database onto another
server in a similiar environment the restore completes.
But database icon status, states that it is loading. I
refresh the databases (PF5) but it does not change.
Next, I run the restore database with recovery and the
restore completes.
Please help me resolve this issue.
Mike
RESTORE DATABASE DATABASE_NAME
from disk = WITH RECOVERYAre you sure that the environment is the same, or that there are no pending
transactions? According to BOL, the WITH RECOVERY option IS the default
option, and should only be required when a database upgrade is required.
Steve
RECOVERY
Instructs the restore operation to roll back any uncommitted transactions.
After the recovery process, the database is ready for use.
If subsequent RESTORE operations (RESTORE LOG, or RESTORE DATABASE from
differential) are planned, NORECOVERY or STANDBY should be specified
instead.
If neither NORECOVERY, RECOVERY, or STANDBY is specified, RECOVERY is the
default. When restoring backup sets from an earlier version of SQL Server, a
database upgrade may be required. This upgrade is performed automatically
when WITH RECOVERY is specified. For more information, see Transaction Log
Backups .
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1deb101c4548a$985d2e00$a401280a@.phx.gbl...
> I have SQL Server 2000 Enterprise Edition with SP3A on my
> Windows 2000 Advanced Server. There is only one
> development database on this server.
> When I restore a backup from this database onto another
> server in a similiar environment the restore completes.
> But database icon status, states that it is loading. I
> refresh the databases (PF5) but it does not change.
> Next, I run the restore database with recovery and the
> restore completes.
> Please help me resolve this issue.
> Mike
>
> RESTORE DATABASE DATABASE_NAME
> from disk => WITH RECOVERY
>|||HI,
It seems you have clicked the option "Non operational, need to load more
transaction logs" in enterprise manager while loading. Execute the below
command from query analyzer to recover the database:-
RESTORE DATABASE <dbname> with RECOVERY
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:1deb101c4548a$985d2e00$a401280a@.phx.gbl...
> I have SQL Server 2000 Enterprise Edition with SP3A on my
> Windows 2000 Advanced Server. There is only one
> development database on this server.
> When I restore a backup from this database onto another
> server in a similiar environment the restore completes.
> But database icon status, states that it is loading. I
> refresh the databases (PF5) but it does not change.
> Next, I run the restore database with recovery and the
> restore completes.
> Please help me resolve this issue.
> Mike
>
> RESTORE DATABASE DATABASE_NAME
> from disk => WITH RECOVERY
>

restore analyse backup from developer edition to standard edition

I did a backup of an analyse service database (cube) on my developer edition of analyse service.(developer machine)

This backup I tried to restore on a standard edition of analyse service. (production machine)

error:

Errors related to feature availability and configuration: The 'Perspectives' feature is not included in the 'Standard Edition' SKU.

Errors in the metadata manager. An error occurred when loading the nr2 perspective, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\sj cube 1.17.db\Sj Mp2.49.cub\Perspective.22.persp.xml'.

Errors in the metadata manager. An error occurred when loading the Sj Mp2 cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\sj cube 1.17.db\Sj Mp2.51.cub.xml'.

(Microsoft.AnalysisServices)

I then tried to delete it, but the same error message.

How to delete this ?

It hurts because you get this message generelly. Not only for this database. No restore/backup of other databases can be done.

BOL quote:

It includes all of the functionality of SQL Server 2005 Enterprise Edition, but is licensed for use as a development and test system, not as a production server. SQL Server 2005 Developer Edition is an ideal choice for independent software vendors (ISVs), consultants, system integrators, solution providers, and corporate developers who build and test applications. You can upgrade SQL Server 2005 Developer Edition for production use.

I believe the error is by default due to the configuration of Standard Edition and mismatch with the features availabel with Developer edition. You might report this to the Microsoft Connect for more information.

Restore a database from Yukon to SQL 2000 SP4 edition?

Hello,
I have a siuation that need restore a testing database that currently running on Yukon server to SQL 2000 SP4 staging server. I am getting an error when I go with filelistonly option to see if its possible.
### Error Starts ###
Server: Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 603. The server supports version 539 and cannot restore or upgrade this database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
### Error Ends ###

Yes, I am trying to downgrade it, any way that I can do?

Thanks in advance.

Sunny Jung

Sunny,

There is no way to downgrade. You can try to export the data and them import it. But this isn't a scenario we test.

Dan

Restore a database from SQL Server 2000 to SQL Server 2005 Express

Hi,
I'm trying to restore a database that existed in SQL Server 2000 to SQL
Server 2005 Express edition and I keep getting the following error:
System.Data.SqlClient.SqlError: Directory lookup for the file (name of the
file) failed with the operating system error 5(Access is denied.).
(Microsoft.SqlServer.Express.Smo)
I backed up the database using SQL Server 2000 and I simply want to restore
the database in 2005 Express.
The system is XP Professional and I am logged on as the administrator.
I'm using SQL Server and Windows Authentication mode in both SQL Server 2000
and in SQL Server 2005 Express.
Any ideas.
Thanks,
--
Scott H.Scott
Any errors in Event Viewer, SQL Server LOG file?
"Scott H." <ScottH@.discussions.microsoft.com> wrote in message
news:FD12F53E-3D00-4733-8FAD-42C4D790C03B@.microsoft.com...
> Hi,
> I'm trying to restore a database that existed in SQL Server 2000 to SQL
> Server 2005 Express edition and I keep getting the following error:
> System.Data.SqlClient.SqlError: Directory lookup for the file (name of the
> file) failed with the operating system error 5(Access is denied.).
> (Microsoft.SqlServer.Express.Smo)
> I backed up the database using SQL Server 2000 and I simply want to
> restore
> the database in 2005 Express.
> The system is XP Professional and I am logged on as the administrator.
> I'm using SQL Server and Windows Authentication mode in both SQL Server
> 2000
> and in SQL Server 2005 Express.
> Any ideas.
> Thanks,
> --
> Scott H.