Moving backup devices

Is there a way to copy backup devices between 2 servers with a script or
something else ? I actually need to move my current installation on a new
server and I don't want to recreate 200 backup devices manually.
Thanks in advance
script out the sysdevices table... eg
USE master
GO
SELECT *
FROM dbo.sysdevices

Moving backup devices

Is there a way to copy backup devices between 2 servers with a script or
something else ? I actually need to move my current installation on a new
server and I don't want to recreate 200 backup devices manually.
Thanks in advancescript out the sysdevices table... eg
USE master
GO
SELECT *
FROM dbo.sysdevices

Moving backup devices

Is there a way to copy backup devices between 2 servers with a script or
something else ? I actually need to move my current installation on a new
server and I don't want to recreate 200 backup devices manually.
Thanks in advancescript out the sysdevices table... eg
USE master
GO
SELECT *
FROM dbo.sysdevices

moving away from cluster to standalone

We have 2 servers on a SQL 2000 cluster and now we would like to move away
from a clustered enviroment to just a standalone machine. Any idea how I
should proceed?
"nobody" <nobody@.nobody.com> wrote in message
news:%231FAGluoHHA.4424@.TK2MSFTNGP03.phx.gbl...
> We have 2 servers on a SQL 2000 cluster and now we would like to move away
> from a clustered enviroment to just a standalone machine. Any idea how I
> should proceed?
Build a new server, install SQL, and migrate databases.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
July 10-13 in Denver
July 16-19 in New York
|||Agreed, there is no procedure for converting a clustered install to a
standalone install.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Russ Kaufmann [MVP]" wrote:

> "nobody" <nobody@.nobody.com> wrote in message
> news:%231FAGluoHHA.4424@.TK2MSFTNGP03.phx.gbl...
> Build a new server, install SQL, and migrate databases.
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
> The next ClusterHelp classes are:
> July 10-13 in Denver
> July 16-19 in New York
>

Moving a DB from 1 Server 2 another

Hi all,
I have a databse on an SQL Server 2000 that I need to move to another
one.
If I can get a network connection between both servers, I can do this
easily
within Enterprise Manager, but what if I need to physically take the DB
to that server? Assuming that I can't get a network connection, how
would
I get the DB into the other server?
I backuped the DB and tried to restore it on a second test server that I
have,
but I could not get the Restore process to locate the backup file.
Thanks for your time and assistance.
SagaSaga,
Did the account have access to the directory containing the backup file?
Try Restore Database --> From Device --> Select Devices...--> Add... -->
Then click the elipses button and choose the backup filename.
Also, check out:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/kb/314546/en-us
HTH
Jerry
"Saga" <antiSpam@.somewhere.com> wrote in message
news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I have a databse on an SQL Server 2000 that I need to move to another one.
> If I can get a network connection between both servers, I can do this
> easily
> within Enterprise Manager, but what if I need to physically take the DB
> to that server? Assuming that I can't get a network connection, how would
> I get the DB into the other server?
> I backuped the DB and tried to restore it on a second test server that I
> have,
> but I could not get the Restore process to locate the backup file.
> Thanks for your time and assistance.
> Saga
>|||Thanks Jerry!
I will have a look at the info that you mention. I got lucky... I was able to
register both SQL Servers in my Enterprise Manager, so the DB transfer
went along perfectly, but I am going to look into the info that you mention
because whenever I will need this I know I will need it bad :-)
Regards
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? Try Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses button and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> I have a databse on an SQL Server 2000 that I need to move to another one.
>> If I can get a network connection between both servers, I can do this easily
>> within Enterprise Manager, but what if I need to physically take the DB
>> to that server? Assuming that I can't get a network connection, how would
>> I get the DB into the other server?
>> I backuped the DB and tried to restore it on a second test server that I have,
>> but I could not get the Restore process to locate the backup file.
>> Thanks for your time and assistance.
>> Saga
>>
>|||PS: I tried the procedure that you outline in your message and the DB restored
beautifully!
Thanks again
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? Try Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses button and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> I have a databse on an SQL Server 2000 that I need to move to another one.
>> If I can get a network connection between both servers, I can do this easily
>> within Enterprise Manager, but what if I need to physically take the DB
>> to that server? Assuming that I can't get a network connection, how would
>> I get the DB into the other server?
>> I backuped the DB and tried to restore it on a second test server that I have,
>> but I could not get the Restore process to locate the backup file.
>> Thanks for your time and assistance.
>> Saga
>>
>

Moving a DB from 1 Server 2 another

Hi all,
I have a databse on an SQL Server 2000 that I need to move to another
one.
If I can get a network connection between both servers, I can do this
easily
within Enterprise Manager, but what if I need to physically take the DB
to that server? Assuming that I can't get a network connection, how
would
I get the DB into the other server?
I backuped the DB and tried to restore it on a second test server that I
have,
but I could not get the Restore process to locate the backup file.
Thanks for your time and assistance.
SagaSaga,
Did the account have access to the directory containing the backup file?
Try Restore Database --> From Device --> Select Devices...--> Add... -->
Then click the elipses button and choose the backup filename.
Also, check out:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/kb/314546/en-us
HTH
Jerry
"Saga" <antiSpam@.somewhere.com> wrote in message
news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I have a databse on an SQL Server 2000 that I need to move to another one.
> If I can get a network connection between both servers, I can do this
> easily
> within Enterprise Manager, but what if I need to physically take the DB
> to that server? Assuming that I can't get a network connection, how would
> I get the DB into the other server?
> I backuped the DB and tried to restore it on a second test server that I
> have,
> but I could not get the Restore process to locate the backup file.
> Thanks for your time and assistance.
> Saga
>|||Thanks Jerry!
I will have a look at the info that you mention. I got lucky... I was able t
o
register both SQL Servers in my Enterprise Manager, so the DB transfer
went along perfectly, but I am going to look into the info that you mention
because whenever I will need this I know I will need it bad :-)
Regards
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? T
ry Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses b
utton and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2
MSFTNGP04.phx.gbl...
>|||PS: I tried the procedure that you outline in your message and the DB restor
ed
beautifully!
Thanks again
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? T
ry Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses b
utton and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2
MSFTNGP04.phx.gbl...
>

move/upgrade MSDE to SQL 2000

Need some help with moving/upgrading 3 MSDE databases (stored locally on 3 different servers) to a single SQL 2000 server (new instance). Can this be done? If so, how??

Thanks for any responsesStop the MSSQL service. Find the MDF and LDF files (C:\Program Files\Microsoft SQL Server\MSSQL\Data\ ) and copy them to the SQL Server. Then attach the databases on the destination. Watch not to overlay any MDF/LDF files on the destination server.sql

Move TempDB Database off of the SAN

I have a system configured with Windows 2000 and SQL Server 2000
Clustering (active/passive). Both SQL Servers have a local E:\ drive
with the same directory structure. I would like to move the tempdb
off of the shared SAN and on to the E:\ drive. I don't foresee any
issues with this but wanted to know if anyone else has encountered
problems with this.
Conceivable it should work but would not be a supported configuration.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||If you would like to put tempdb on a different disk (for performance reasons)
you'd be better to create a new disk on a different disk pool on your SAN.
That way, you'd keep your support options open.
|||> I have a system configured with Windows 2000 and SQL Server 2000
> Clustering (active/passive). Both SQL Servers have a local E:\ drive
> with the same directory structure. I would like to move the tempdb
> off of the shared SAN and on to the E:\ drive. I don't foresee any
> issues with this but wanted to know if anyone else has encountered
> problems with this.
I am vaguely trying to do the same. But how do you plan to make your local
disk visible as a resource of the cluster ? If you cannot make it a
resource of the cluster, you cannot make it recognized...
I am trying to add it as a disk share resource, but it is not accepted by
SQL Server in cluster, even with trace flag 1807.
Did someone manage do do it ?
thanks in advance,
rudi

Move TempDB Database off of the SAN

I have a system configured with Windows 2000 and SQL Server 2000
Clustering (active/passive). Both SQL Servers have a local E:\ drive
with the same directory structure. I would like to move the tempdb
off of the shared SAN and on to the E:\ drive. I don't foresee any
issues with this but wanted to know if anyone else has encountered
problems with this."Douglara" <renee.douglas@.ps.net> wrote in message
news:afc82404.0408231344.1f60247d@.posting.google.c om...
> I have a system configured with Windows 2000 and SQL Server 2000
> Clustering (active/passive). Both SQL Servers have a local E:\ drive
> with the same directory structure. I would like to move the tempdb
> off of the shared SAN and on to the E:\ drive. I don't foresee any
> issues with this but wanted to know if anyone else has encountered
> problems with this.

In theory it should work since the tempdb is recreated at startup.

But I'd ask why? I'm assuming you're looking for a performance improvement?

And suggest asking over in the microsoft.public.sqlserver.clustering group
to be sure.

move or upgrade MSDE to Sql server 2000 server

We have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.
ThanksWe have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.

Thanks
See this http://support.microsoft.com/default.aspx?scid=kb;en-us;815013#2 (http://support.microsoft.com/default.aspx?scid=kb;en-us;815013#2)|||Let's say I understand that MS site. How do the 3 MSDE databases get into 1 SQL database?

Thanks...|||Let's say I understand that MS site. How do the 3 MSDE databases get into 1 SQL database?

Thanks...
Oops!! Sorry,its my mistake ,I paste the wrong link .Please see this one...
http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html (http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html)
It may help you...