Hi, I am updagrading database server to new datbase server.
I want to transfer the backup devices info from old server to new
server.
is there any way so that I can script backup devices on old server
and deploy them to new server.
This will save me lot of time.
Thanks in advance
Hi DKR,
I don't think you can script the backup devices from any of the management
tools.
SQL DMO has a Backup Device object with a Script method but that means you
will need to write procedural code for that.
See
http://msdn.microsoft.com/library/de...f_m_s_8wz6.asp
The backup devices are stored in the "sysdevices" table in the master
database.
Restoring the master DB will restore all backup devices but it will have
many more implications that you usually don't want to mess with.
Since each device is stored as a simple single row in sysdevices, Perhaps
the easiest way will be to simply export the data from the table and import
it back on your new installation.
The sysdevices table is a "stand alone" table with no reference to any other
tables so it should be pretty straight forward.
You will need to configure the server to allow updates to system tables
using sp_configure:
EXEC sp_configure 'Show Advnaced Options',1
RECONFIGURE
EXEC sp_configure 'Allow Updates',1
RECONFIGURE WITH OVERRIDE
INSERT INTO master..sysdevices
SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
-- 0 is used for the system DB files
EXEC sp_configure 'Allow Updates',0
RECONFIGURE
* WARNING - Messing with system tables is not recommended and not supported
by MS.
HTH
Ami
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>
|||Hi,
You could write a script with system stored procedure sp_addumpdevice based
on MASTER..SYSDEVICES table.
Thanks
Hari
SQL Server MVP
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>
|||Thank you very much.
"Ami Levin" <XXX__NO_SPAM__XXX__Levin_Ami@.Yahoo.com> wrote in message
news:OL$SDEJeFHA.2420@.TK2MSFTNGP15.phx.gbl...
> Hi DKR,
> I don't think you can script the backup devices from any of the management
> tools.
> SQL DMO has a Backup Device object with a Script method but that means you
> will need to write procedural code for that.
> See
>
http://msdn.microsoft.com/library/de...f_m_s_8wz6.asp
> The backup devices are stored in the "sysdevices" table in the master
> database.
> Restoring the master DB will restore all backup devices but it will have
> many more implications that you usually don't want to mess with.
> Since each device is stored as a simple single row in sysdevices, Perhaps
> the easiest way will be to simply export the data from the table and
import
> it back on your new installation.
> The sysdevices table is a "stand alone" table with no reference to any
other
> tables so it should be pretty straight forward.
> You will need to configure the server to allow updates to system tables
> using sp_configure:
> EXEC sp_configure 'Show Advnaced Options',1
> RECONFIGURE
> EXEC sp_configure 'Allow Updates',1
> RECONFIGURE WITH OVERRIDE
> INSERT INTO master..sysdevices
> SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
> -- 0 is used for the system DB files
> EXEC sp_configure 'Allow Updates',0
> RECONFIGURE
>
> * WARNING - Messing with system tables is not recommended and not
supported
> by MS.
> HTH
> Ami
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
>
Showing posts with label transfer. Show all posts
Showing posts with label transfer. Show all posts
Thursday, March 22, 2012
backup devices export
Hi, I am updagrading database server to new datbase server.
I want to transfer the backup devices info from old server to new
server.
is there any way so that I can script backup devices on old server
and deploy them to new server.
This will save me lot of time.
Thanks in advanceHi DKR,
I don't think you can script the backup devices from any of the management
tools.
SQL DMO has a Backup Device object with a Script method but that means you
will need to write procedural code for that.
See
http://msdn.microsoft.com/library/d...r />
_8wz6.asp
The backup devices are stored in the "sysdevices" table in the master
database.
Restoring the master DB will restore all backup devices but it will have
many more implications that you usually don't want to mess with.
Since each device is stored as a simple single row in sysdevices, Perhaps
the easiest way will be to simply export the data from the table and import
it back on your new installation.
The sysdevices table is a "stand alone" table with no reference to any other
tables so it should be pretty straight forward.
You will need to configure the server to allow updates to system tables
using sp_configure:
EXEC sp_configure 'Show Advnaced Options',1
RECONFIGURE
EXEC sp_configure 'Allow Updates',1
RECONFIGURE WITH OVERRIDE
INSERT INTO master..sysdevices
SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
-- 0 is used for the system DB files
EXEC sp_configure 'Allow Updates',0
RECONFIGURE
* WARNING - Messing with system tables is not recommended and not supported
by MS.
HTH
Ami
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>|||Hi,
You could write a script with system stored procedure sp_addumpdevice based
on MASTER..SYSDEVICES table.
Thanks
Hari
SQL Server MVP
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>|||Thank you very much.
"Ami Levin" <XXX__NO_SPAM__XXX__Levin_Ami@.Yahoo.com> wrote in message
news:OL$SDEJeFHA.2420@.TK2MSFTNGP15.phx.gbl...
> Hi DKR,
> I don't think you can script the backup devices from any of the management
> tools.
> SQL DMO has a Backup Device object with a Script method but that means you
> will need to write procedural code for that.
> See
>
http://msdn.microsoft.com/library/d...ef_m_s_8wz6.asp[
vbcol=seagreen]
> The backup devices are stored in the "sysdevices" table in the master
> database.
> Restoring the master DB will restore all backup devices but it will have
> many more implications that you usually don't want to mess with.
> Since each device is stored as a simple single row in sysdevices, Perhaps
> the easiest way will be to simply export the data from the table and[/vbcol]
import
> it back on your new installation.
> The sysdevices table is a "stand alone" table with no reference to any
other
> tables so it should be pretty straight forward.
> You will need to configure the server to allow updates to system tables
> using sp_configure:
> EXEC sp_configure 'Show Advnaced Options',1
> RECONFIGURE
> EXEC sp_configure 'Allow Updates',1
> RECONFIGURE WITH OVERRIDE
> INSERT INTO master..sysdevices
> SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
> -- 0 is used for the system DB files
> EXEC sp_configure 'Allow Updates',0
> RECONFIGURE
>
> * WARNING - Messing with system tables is not recommended and not
supported
> by MS.
> HTH
> Ami
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
>
I want to transfer the backup devices info from old server to new
server.
is there any way so that I can script backup devices on old server
and deploy them to new server.
This will save me lot of time.
Thanks in advanceHi DKR,
I don't think you can script the backup devices from any of the management
tools.
SQL DMO has a Backup Device object with a Script method but that means you
will need to write procedural code for that.
See
http://msdn.microsoft.com/library/d...r />
_8wz6.asp
The backup devices are stored in the "sysdevices" table in the master
database.
Restoring the master DB will restore all backup devices but it will have
many more implications that you usually don't want to mess with.
Since each device is stored as a simple single row in sysdevices, Perhaps
the easiest way will be to simply export the data from the table and import
it back on your new installation.
The sysdevices table is a "stand alone" table with no reference to any other
tables so it should be pretty straight forward.
You will need to configure the server to allow updates to system tables
using sp_configure:
EXEC sp_configure 'Show Advnaced Options',1
RECONFIGURE
EXEC sp_configure 'Allow Updates',1
RECONFIGURE WITH OVERRIDE
INSERT INTO master..sysdevices
SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
-- 0 is used for the system DB files
EXEC sp_configure 'Allow Updates',0
RECONFIGURE
* WARNING - Messing with system tables is not recommended and not supported
by MS.
HTH
Ami
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>|||Hi,
You could write a script with system stored procedure sp_addumpdevice based
on MASTER..SYSDEVICES table.
Thanks
Hari
SQL Server MVP
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>|||Thank you very much.
"Ami Levin" <XXX__NO_SPAM__XXX__Levin_Ami@.Yahoo.com> wrote in message
news:OL$SDEJeFHA.2420@.TK2MSFTNGP15.phx.gbl...
> Hi DKR,
> I don't think you can script the backup devices from any of the management
> tools.
> SQL DMO has a Backup Device object with a Script method but that means you
> will need to write procedural code for that.
> See
>
http://msdn.microsoft.com/library/d...ef_m_s_8wz6.asp[
vbcol=seagreen]
> The backup devices are stored in the "sysdevices" table in the master
> database.
> Restoring the master DB will restore all backup devices but it will have
> many more implications that you usually don't want to mess with.
> Since each device is stored as a simple single row in sysdevices, Perhaps
> the easiest way will be to simply export the data from the table and[/vbcol]
import
> it back on your new installation.
> The sysdevices table is a "stand alone" table with no reference to any
other
> tables so it should be pretty straight forward.
> You will need to configure the server to allow updates to system tables
> using sp_configure:
> EXEC sp_configure 'Show Advnaced Options',1
> RECONFIGURE
> EXEC sp_configure 'Allow Updates',1
> RECONFIGURE WITH OVERRIDE
> INSERT INTO master..sysdevices
> SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
> -- 0 is used for the system DB files
> EXEC sp_configure 'Allow Updates',0
> RECONFIGURE
>
> * WARNING - Messing with system tables is not recommended and not
supported
> by MS.
> HTH
> Ami
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
>
backup devices export
Hi, I am updagrading database server to new datbase server.
I want to transfer the backup devices info from old server to new
server.
is there any way so that I can script backup devices on old server
and deploy them to new server.
This will save me lot of time.
Thanks in advanceHi DKR,
I don't think you can script the backup devices from any of the management
tools.
SQL DMO has a Backup Device object with a Script method but that means you
will need to write procedural code for that.
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_s_8wz6.asp
The backup devices are stored in the "sysdevices" table in the master
database.
Restoring the master DB will restore all backup devices but it will have
many more implications that you usually don't want to mess with.
Since each device is stored as a simple single row in sysdevices, Perhaps
the easiest way will be to simply export the data from the table and import
it back on your new installation.
The sysdevices table is a "stand alone" table with no reference to any other
tables so it should be pretty straight forward.
You will need to configure the server to allow updates to system tables
using sp_configure:
EXEC sp_configure 'Show Advnaced Options',1
RECONFIGURE
EXEC sp_configure 'Allow Updates',1
RECONFIGURE WITH OVERRIDE
INSERT INTO master..sysdevices
SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
-- 0 is used for the system DB files
EXEC sp_configure 'Allow Updates',0
RECONFIGURE
* WARNING - Messing with system tables is not recommended and not supported
by MS.
HTH
Ami
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>|||Hi,
You could write a script with system stored procedure sp_addumpdevice based
on MASTER..SYSDEVICES table.
Thanks
Hari
SQL Server MVP
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>|||Thank you very much.
"Ami Levin" <XXX__NO_SPAM__XXX__Levin_Ami@.Yahoo.com> wrote in message
news:OL$SDEJeFHA.2420@.TK2MSFTNGP15.phx.gbl...
> Hi DKR,
> I don't think you can script the backup devices from any of the management
> tools.
> SQL DMO has a Backup Device object with a Script method but that means you
> will need to write procedural code for that.
> See
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_s_8wz6.asp
> The backup devices are stored in the "sysdevices" table in the master
> database.
> Restoring the master DB will restore all backup devices but it will have
> many more implications that you usually don't want to mess with.
> Since each device is stored as a simple single row in sysdevices, Perhaps
> the easiest way will be to simply export the data from the table and
import
> it back on your new installation.
> The sysdevices table is a "stand alone" table with no reference to any
other
> tables so it should be pretty straight forward.
> You will need to configure the server to allow updates to system tables
> using sp_configure:
> EXEC sp_configure 'Show Advnaced Options',1
> RECONFIGURE
> EXEC sp_configure 'Allow Updates',1
> RECONFIGURE WITH OVERRIDE
> INSERT INTO master..sysdevices
> SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
> -- 0 is used for the system DB files
> EXEC sp_configure 'Allow Updates',0
> RECONFIGURE
>
> * WARNING - Messing with system tables is not recommended and not
supported
> by MS.
> HTH
> Ami
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> > Hi, I am updagrading database server to new datbase server.
> > I want to transfer the backup devices info from old server to new
> > server.
> > is there any way so that I can script backup devices on old server
> > and deploy them to new server.
> > This will save me lot of time.
> >
> > Thanks in advance
> >
> >
>
I want to transfer the backup devices info from old server to new
server.
is there any way so that I can script backup devices on old server
and deploy them to new server.
This will save me lot of time.
Thanks in advanceHi DKR,
I don't think you can script the backup devices from any of the management
tools.
SQL DMO has a Backup Device object with a Script method but that means you
will need to write procedural code for that.
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_s_8wz6.asp
The backup devices are stored in the "sysdevices" table in the master
database.
Restoring the master DB will restore all backup devices but it will have
many more implications that you usually don't want to mess with.
Since each device is stored as a simple single row in sysdevices, Perhaps
the easiest way will be to simply export the data from the table and import
it back on your new installation.
The sysdevices table is a "stand alone" table with no reference to any other
tables so it should be pretty straight forward.
You will need to configure the server to allow updates to system tables
using sp_configure:
EXEC sp_configure 'Show Advnaced Options',1
RECONFIGURE
EXEC sp_configure 'Allow Updates',1
RECONFIGURE WITH OVERRIDE
INSERT INTO master..sysdevices
SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
-- 0 is used for the system DB files
EXEC sp_configure 'Allow Updates',0
RECONFIGURE
* WARNING - Messing with system tables is not recommended and not supported
by MS.
HTH
Ami
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>|||Hi,
You could write a script with system stored procedure sp_addumpdevice based
on MASTER..SYSDEVICES table.
Thanks
Hari
SQL Server MVP
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi, I am updagrading database server to new datbase server.
> I want to transfer the backup devices info from old server to new
> server.
> is there any way so that I can script backup devices on old server
> and deploy them to new server.
> This will save me lot of time.
> Thanks in advance
>|||Thank you very much.
"Ami Levin" <XXX__NO_SPAM__XXX__Levin_Ami@.Yahoo.com> wrote in message
news:OL$SDEJeFHA.2420@.TK2MSFTNGP15.phx.gbl...
> Hi DKR,
> I don't think you can script the backup devices from any of the management
> tools.
> SQL DMO has a Backup Device object with a Script method but that means you
> will need to write procedural code for that.
> See
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_s_8wz6.asp
> The backup devices are stored in the "sysdevices" table in the master
> database.
> Restoring the master DB will restore all backup devices but it will have
> many more implications that you usually don't want to mess with.
> Since each device is stored as a simple single row in sysdevices, Perhaps
> the easiest way will be to simply export the data from the table and
import
> it back on your new installation.
> The sysdevices table is a "stand alone" table with no reference to any
other
> tables so it should be pretty straight forward.
> You will need to configure the server to allow updates to system tables
> using sp_configure:
> EXEC sp_configure 'Show Advnaced Options',1
> RECONFIGURE
> EXEC sp_configure 'Allow Updates',1
> RECONFIGURE WITH OVERRIDE
> INSERT INTO master..sysdevices
> SELECT * FROM <previous_sysdevices> WHERE cntrltype > 0
> -- 0 is used for the system DB files
> EXEC sp_configure 'Allow Updates',0
> RECONFIGURE
>
> * WARNING - Messing with system tables is not recommended and not
supported
> by MS.
> HTH
> Ami
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23RoyzSIeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> > Hi, I am updagrading database server to new datbase server.
> > I want to transfer the backup devices info from old server to new
> > server.
> > is there any way so that I can script backup devices on old server
> > and deploy them to new server.
> > This will save me lot of time.
> >
> > Thanks in advance
> >
> >
>
Wednesday, March 7, 2012
backup and restore Question
I had used to make full backup of a database and using winzip to compress
the file to transfer it via email to another location. And because of the
big email attachement of the compressed database I didn't succeed in
transfering the data. Then I tried to alter the database as adding a
secondary group file with 2 files.
and I tried to backup the files each indivually and on the another location
(SERVER) I tried to restore the files but I didn't succeed.
How Can I achieve this goal without any errors ?How about just backup the db and then handling both files? When you backup
the db, both files are backed up.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Whatever number of files you have, the db backup should back them all up.
Then you can compress them all, mail them all, restore the db with them
all -- treating the group of files the same as if there were only one file.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
> The Goal is to get 3 or more files to compress and send via email not one
> big file
>
> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
> > How about just backup the db and then handling both files? When you
> backup
> > the db, both files are backed up.
> >
> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> > > I had used to make full backup of a database and using winzip to
> compress
> > > the file to transfer it via email to another location. And because of
> the
> > > big email attachement of the compressed database I didn't succeed in
> > > transfering the data. Then I tried to alter the database as adding a
> > > secondary group file with 2 files.
> > > and I tried to backup the files each indivually and on the another
> > location
> > > (SERVER) I tried to restore the files but I didn't succeed.
> > > How Can I achieve this goal without any errors ?
> > >
> > >
> >
> >
>|||I backup DBs on production server, zip them into a RAR file (170 MB) and
schedule a DTS job to FTP the file to an off-site location. How big is your
attachment?
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Doesn't winzip give an option to split the zip file into
multiple files? Don't have it installed here to check.
>--Original Message--
>Whatever number of files you have, the db backup should
back them all up.
>Then you can compress them all, mail them all, restore
the db with them
>all -- treating the group of files the same as if there
were only one file.
>"Awada" <awada@.pharmacare-ltd.com> wrote in message
>news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
>> The Goal is to get 3 or more files to compress and send
via email not one
>> big file
>>
>> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
>> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
>> > How about just backup the db and then handling both
files? When you
>> backup
>> > the db, both files are backed up.
>> >
>> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
>> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
>> > > I had used to make full backup of a database and
using winzip to
>> compress
>> > > the file to transfer it via email to another
location. And because of
>> the
>> > > big email attachement of the compressed database I
didn't succeed in
>> > > transfering the data. Then I tried to alter the
database as adding a
>> > > secondary group file with 2 files.
>> > > and I tried to backup the files each indivually and
on the another
>> > location
>> > > (SERVER) I tried to restore the files but I didn't
succeed.
>> > > How Can I achieve this goal without any errors ?
>> > >
>> > >
>> >
>> >
>>
>
>.
>|||Awada -
I follow this process -
1. Backup the Database
2. Rar the DB (Ours is too large for winzip)
3. FTP the database to the remote server
4. Unrar and restore on remote server
This whole process can be automated in a couple of different ways if
you want to (I did).
HTH
"Awada" <awada@.pharmacare-ltd.com> wrote in message news:<OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl>...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
the file to transfer it via email to another location. And because of the
big email attachement of the compressed database I didn't succeed in
transfering the data. Then I tried to alter the database as adding a
secondary group file with 2 files.
and I tried to backup the files each indivually and on the another location
(SERVER) I tried to restore the files but I didn't succeed.
How Can I achieve this goal without any errors ?How about just backup the db and then handling both files? When you backup
the db, both files are backed up.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Whatever number of files you have, the db backup should back them all up.
Then you can compress them all, mail them all, restore the db with them
all -- treating the group of files the same as if there were only one file.
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
> The Goal is to get 3 or more files to compress and send via email not one
> big file
>
> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
> > How about just backup the db and then handling both files? When you
> backup
> > the db, both files are backed up.
> >
> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> > > I had used to make full backup of a database and using winzip to
> compress
> > > the file to transfer it via email to another location. And because of
> the
> > > big email attachement of the compressed database I didn't succeed in
> > > transfering the data. Then I tried to alter the database as adding a
> > > secondary group file with 2 files.
> > > and I tried to backup the files each indivually and on the another
> > location
> > > (SERVER) I tried to restore the files but I didn't succeed.
> > > How Can I achieve this goal without any errors ?
> > >
> > >
> >
> >
>|||I backup DBs on production server, zip them into a RAR file (170 MB) and
schedule a DTS job to FTP the file to an off-site location. How big is your
attachment?
"Awada" <awada@.pharmacare-ltd.com> wrote in message
news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another
location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
>|||Doesn't winzip give an option to split the zip file into
multiple files? Don't have it installed here to check.
>--Original Message--
>Whatever number of files you have, the db backup should
back them all up.
>Then you can compress them all, mail them all, restore
the db with them
>all -- treating the group of files the same as if there
were only one file.
>"Awada" <awada@.pharmacare-ltd.com> wrote in message
>news:OFvJ0PxPDHA.3236@.TK2MSFTNGP10.phx.gbl...
>> The Goal is to get 3 or more files to compress and send
via email not one
>> big file
>>
>> "Quentin Ran" <quentinran@.yahoo.com> wrote in message
>> news:#m6oUIxPDHA.3192@.TK2MSFTNGP10.phx.gbl...
>> > How about just backup the db and then handling both
files? When you
>> backup
>> > the db, both files are backed up.
>> >
>> > "Awada" <awada@.pharmacare-ltd.com> wrote in message
>> > news:OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl...
>> > > I had used to make full backup of a database and
using winzip to
>> compress
>> > > the file to transfer it via email to another
location. And because of
>> the
>> > > big email attachement of the compressed database I
didn't succeed in
>> > > transfering the data. Then I tried to alter the
database as adding a
>> > > secondary group file with 2 files.
>> > > and I tried to backup the files each indivually and
on the another
>> > location
>> > > (SERVER) I tried to restore the files but I didn't
succeed.
>> > > How Can I achieve this goal without any errors ?
>> > >
>> > >
>> >
>> >
>>
>
>.
>|||Awada -
I follow this process -
1. Backup the Database
2. Rar the DB (Ours is too large for winzip)
3. FTP the database to the remote server
4. Unrar and restore on remote server
This whole process can be automated in a couple of different ways if
you want to (I did).
HTH
"Awada" <awada@.pharmacare-ltd.com> wrote in message news:<OAnA47wPDHA.1148@.TK2MSFTNGP11.phx.gbl>...
> I had used to make full backup of a database and using winzip to compress
> the file to transfer it via email to another location. And because of the
> big email attachement of the compressed database I didn't succeed in
> transfering the data. Then I tried to alter the database as adding a
> secondary group file with 2 files.
> and I tried to backup the files each indivually and on the another location
> (SERVER) I tried to restore the files but I didn't succeed.
> How Can I achieve this goal without any errors ?
Sunday, February 19, 2012
Backup /restore DB
hi,
I want to know if there is a way - other than backup and restore database (because restore takes too much time as the DB size grows) - to transfer all the data from one database on the server to another on a local SQLServer. it has to be done daily, so that the manager will always have an updated copy of the data on his machine.
I want to know if there is a way - other than backup and restore database (because restore takes too much time as the DB size grows) - to transfer all the data from one database on the server to another on a local SQLServer. it has to be done daily, so that the manager will always have an updated copy of the data on his machine.
Any help?
Thanks in advanceYou can enable Replication instead.
Subscribe to:
Posts (Atom)