When I try to take a Transaction log backup of a database (Recovery model
set to Full), I get an option to truncate the transaction log by checking
"Remove inactive entries from transaction log" check box in the backup
dialog. This basically causes the inactive portion of the transaction log
(where transaction is completes, either rolled back are committed) to be
truncated. So this potentially leads to saving of huge amount of hard disk
space.
Now, when I setup log shipping is there any similar option I can set on the
primary database? After every transaction log backup I want inactive entries
from the transaction log to be removed. Is there any way to do this? If yes,
how?. If no, why is that so? Once the backup is taken inactive log entries
on the primary database are of no use to log ship, right?
Rathna RajThe option in the backup dialog is very misleading. It basically means that
EM does *not* send the WITH NO_TRUNCATE option. This option is designed for
doing an "emergency" backup in case the database is corrupted, and I have
communicated to MS that the dialog shouldn't be misleading in this way. The
normal way to do log backup is by not specifying this option (having the
checkbox checked (I believe), the default). If the log shipping was written
by a sane individual ;-), then it should not specify this option, I.e., you
already have the desired behavior. To be certain, use a Profiler trace to
see what is going on.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rathna Raj" <RathnaRajT@.icode.com> wrote in message
news:%2365JEWJyDHA.1272@.TK2MSFTNGP12.phx.gbl...
> When I try to take a Transaction log backup of a database (Recovery model
> set to Full), I get an option to truncate the transaction log by checking
> "Remove inactive entries from transaction log" check box in the backup
> dialog. This basically causes the inactive portion of the transaction log
> (where transaction is completes, either rolled back are committed) to be
> truncated. So this potentially leads to saving of huge amount of hard disk
> space.
> Now, when I setup log shipping is there any similar option I can set on
the
> primary database? After every transaction log backup I want inactive
entries
> from the transaction log to be removed. Is there any way to do this? If
yes,
> how?. If no, why is that so? Once the backup is taken inactive log entries
> on the primary database are of no use to log ship, right?
> Rathna Raj
>|||Hi Rathna,
Thanks for your post. Based on my research, log shipping does done backup
log part, so transaction log should not be large. Therefore, it seems that
truncating the transaction log of the primary server manually in log
shipping is not necessary.
For more information regarding log shipping, please refer to the following
article on SQL Server Books Online. Also, the example in this article will
help describe how the log shipping works.
Topic; "Log Shipping"
Thanks for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.sql
Showing posts with label backup. Show all posts
Showing posts with label backup. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Remove Backup History
I have done a database backup and store the backup file in a harddisk folder.
Now,
I want to remove the backup history log from the Restore Database dialog
window but I could not find the command to remove it.
exec msdb.dbo.sp_delete_backuphistory
"JSL" <JSL@.discussions.microsoft.com> wrote in message
news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> I have done a database backup and store the backup file in a harddisk
folder.
> Now,
> I want to remove the backup history log from the Restore Database dialog
> window but I could not find the command to remove it.
|||Thanks a lot. It works.
"Hassan" wrote:
> exec msdb.dbo.sp_delete_backuphistory
> "JSL" <JSL@.discussions.microsoft.com> wrote in message
> news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> folder.
>
>
Now,
I want to remove the backup history log from the Restore Database dialog
window but I could not find the command to remove it.
exec msdb.dbo.sp_delete_backuphistory
"JSL" <JSL@.discussions.microsoft.com> wrote in message
news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> I have done a database backup and store the backup file in a harddisk
folder.
> Now,
> I want to remove the backup history log from the Restore Database dialog
> window but I could not find the command to remove it.
|||Thanks a lot. It works.
"Hassan" wrote:
> exec msdb.dbo.sp_delete_backuphistory
> "JSL" <JSL@.discussions.microsoft.com> wrote in message
> news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> folder.
>
>
Remove Backup History
I have done a database backup and store the backup file in a harddisk folder
.
Now,
I want to remove the backup history log from the Restore Database dialog
window but I could not find the command to remove it.exec msdb.dbo.sp_delete_backuphistory
"JSL" <JSL@.discussions.microsoft.com> wrote in message
news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> I have done a database backup and store the backup file in a harddisk
folder.
> Now,
> I want to remove the backup history log from the Restore Database dialog
> window but I could not find the command to remove it.|||Thanks a lot. It works.
"Hassan" wrote:
> exec msdb.dbo.sp_delete_backuphistory
> "JSL" <JSL@.discussions.microsoft.com> wrote in message
> news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> folder.
>
>
.
Now,
I want to remove the backup history log from the Restore Database dialog
window but I could not find the command to remove it.exec msdb.dbo.sp_delete_backuphistory
"JSL" <JSL@.discussions.microsoft.com> wrote in message
news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> I have done a database backup and store the backup file in a harddisk
folder.
> Now,
> I want to remove the backup history log from the Restore Database dialog
> window but I could not find the command to remove it.|||Thanks a lot. It works.
"Hassan" wrote:
> exec msdb.dbo.sp_delete_backuphistory
> "JSL" <JSL@.discussions.microsoft.com> wrote in message
> news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> folder.
>
>
Remove Backup History
I have done a database backup and store the backup file in a harddisk folder.
Now,
I want to remove the backup history log from the Restore Database dialog
window but I could not find the command to remove it.exec msdb.dbo.sp_delete_backuphistory
"JSL" <JSL@.discussions.microsoft.com> wrote in message
news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> I have done a database backup and store the backup file in a harddisk
folder.
> Now,
> I want to remove the backup history log from the Restore Database dialog
> window but I could not find the command to remove it.|||Thanks a lot. It works.
"Hassan" wrote:
> exec msdb.dbo.sp_delete_backuphistory
> "JSL" <JSL@.discussions.microsoft.com> wrote in message
> news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> > I have done a database backup and store the backup file in a harddisk
> folder.
> > Now,
> > I want to remove the backup history log from the Restore Database dialog
> > window but I could not find the command to remove it.
>
>sql
Now,
I want to remove the backup history log from the Restore Database dialog
window but I could not find the command to remove it.exec msdb.dbo.sp_delete_backuphistory
"JSL" <JSL@.discussions.microsoft.com> wrote in message
news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> I have done a database backup and store the backup file in a harddisk
folder.
> Now,
> I want to remove the backup history log from the Restore Database dialog
> window but I could not find the command to remove it.|||Thanks a lot. It works.
"Hassan" wrote:
> exec msdb.dbo.sp_delete_backuphistory
> "JSL" <JSL@.discussions.microsoft.com> wrote in message
> news:877ED168-5E2E-44CA-ABD8-9E16F83B9AA1@.microsoft.com...
> > I have done a database backup and store the backup file in a harddisk
> folder.
> > Now,
> > I want to remove the backup history log from the Restore Database dialog
> > window but I could not find the command to remove it.
>
>sql
Remove Backup Files ?
We are using SQL Server 2000 with SP3 installed.
In the database maintenance plan, we have chosen
to "Remove files older than 1 week" for the production
database.
We would like to know does the setting mean that "SQL
Server will remove backup files generated by the DB
Maitenance Plan will be removed if it is older than 1
week ?". This is because we find that there are some DB
backups (Done in July last year) exist in that directory.
ThanksBelow KB might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303292&Product=sql2k
Also, check out below great troubleshooting suggestions from Bill H at MS:
-- Log files don't delete --
This is likely to be either a permissions problem or a sharing violation
problem. The maintenance plan is run as a job, and jobs are run by the
SQLServerAgent service.
Permissions:
1. Determine the startup account for the SQLServerAgent service
(Start|Programs|Administrative tools|Services|SQLServerAgent|Startup). This
account is the security context for jobs, and thus the maintenance plan.
2. If SQLServerAgent is started using LocalSystem (as opposed to a domain
account) then skip step 3.
3. On that box, log onto NT as that account. Using Explorer, attempt to
delete an expired backup. If that succeeds then go to Sharing Violation
section.
4. Log onto NT with an account that is an administrator and use Explorer to
look at the Properties|Security of the folder (where the backups reside)
and ensure the SQLServerAgent startup account has Full Control. If the
SQLServerAgent startup account is LocalSystem, then the account to consider
is SYSTEM.
5. In NT, if an account is a member of an NT group, and if that group has
Access is Denied, then that account will have Access is Denied, even if
that account is also a member of the Administrators group. Thus you may
need to check group permissions (if the Startup Account is a member of a
group).
6. Keep in mind that permissions (by default) are inherited from a parent
folder. Thus, if the backups are stored in C:\bak, and if someone had
denied permission to the SQLServerAgent startup account for C:\, then
C:\bak will inherit access is denied.
Sharing violation:
This is likely to be rooted in a timing issue, with the most likely cause
being another scheduled process (such as NT Backup or Anti-Virus software)
having the backup file open at the time when the SQLServerAgent (i.e., the
maintenance plan job) tried to delete it.
1. Download filemon and handle from www.sysinternals.com.
2. I am not sure whether filemon can be scheduled, or you might be able to
use NT scheduling services to start filemon just before the maintenance
plan job is started, but the filemon log can become very large, so it would
be best to start it some short time before the maintenance plan starts.
3. Inspect the filemon log for another process that has that backup file
open (if your lucky enough to have started filemon before this other
process grabs the backup folder), and inspect the log for the results when
the SQLServerAgent agent attempts to open that same file.
4. Schedule the job or that other process to do their work at different
times.
5. You can use the handle utility if you are around at the time when the
job is scheduled to run.
If the backup files are going to a \\share or a mapped drive (as opposed to
local drive), then you will need to modify the above (with respect to where
the tests and utilities are run).
Finally, inspection of the maintenance plan's history report might be
useful.
Thanks,
Bill Hollinshead
Microsoft, SQL Server
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Roger Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:045801c39db5$02521100$a601280a@.phx.gbl...
> We are using SQL Server 2000 with SP3 installed.
> In the database maintenance plan, we have chosen
> to "Remove files older than 1 week" for the production
> database.
> We would like to know does the setting mean that "SQL
> Server will remove backup files generated by the DB
> Maitenance Plan will be removed if it is older than 1
> week ?". This is because we find that there are some DB
> backups (Done in July last year) exist in that directory.
> Thanks|||Dear Tibor,
Thank you for your advice.
However, what I missed in last message is that -
Is it possible to make ad hoc backup of the production
database in the same directory where "Daily backup is
generated by the database maintenance plan that 'Remove
files older than 1 week' option is chosen for the
production database".
This is because if the "Database Maintenance Plan" only
remove backups generated by itself, it is perfect for us
to put ad hoc backup there as we don't want to create
another directory for holding ad hoc backup.
Thanks
In the database maintenance plan, we have chosen
to "Remove files older than 1 week" for the production
database.
We would like to know does the setting mean that "SQL
Server will remove backup files generated by the DB
Maitenance Plan will be removed if it is older than 1
week ?". This is because we find that there are some DB
backups (Done in July last year) exist in that directory.
ThanksBelow KB might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303292&Product=sql2k
Also, check out below great troubleshooting suggestions from Bill H at MS:
-- Log files don't delete --
This is likely to be either a permissions problem or a sharing violation
problem. The maintenance plan is run as a job, and jobs are run by the
SQLServerAgent service.
Permissions:
1. Determine the startup account for the SQLServerAgent service
(Start|Programs|Administrative tools|Services|SQLServerAgent|Startup). This
account is the security context for jobs, and thus the maintenance plan.
2. If SQLServerAgent is started using LocalSystem (as opposed to a domain
account) then skip step 3.
3. On that box, log onto NT as that account. Using Explorer, attempt to
delete an expired backup. If that succeeds then go to Sharing Violation
section.
4. Log onto NT with an account that is an administrator and use Explorer to
look at the Properties|Security of the folder (where the backups reside)
and ensure the SQLServerAgent startup account has Full Control. If the
SQLServerAgent startup account is LocalSystem, then the account to consider
is SYSTEM.
5. In NT, if an account is a member of an NT group, and if that group has
Access is Denied, then that account will have Access is Denied, even if
that account is also a member of the Administrators group. Thus you may
need to check group permissions (if the Startup Account is a member of a
group).
6. Keep in mind that permissions (by default) are inherited from a parent
folder. Thus, if the backups are stored in C:\bak, and if someone had
denied permission to the SQLServerAgent startup account for C:\, then
C:\bak will inherit access is denied.
Sharing violation:
This is likely to be rooted in a timing issue, with the most likely cause
being another scheduled process (such as NT Backup or Anti-Virus software)
having the backup file open at the time when the SQLServerAgent (i.e., the
maintenance plan job) tried to delete it.
1. Download filemon and handle from www.sysinternals.com.
2. I am not sure whether filemon can be scheduled, or you might be able to
use NT scheduling services to start filemon just before the maintenance
plan job is started, but the filemon log can become very large, so it would
be best to start it some short time before the maintenance plan starts.
3. Inspect the filemon log for another process that has that backup file
open (if your lucky enough to have started filemon before this other
process grabs the backup folder), and inspect the log for the results when
the SQLServerAgent agent attempts to open that same file.
4. Schedule the job or that other process to do their work at different
times.
5. You can use the handle utility if you are around at the time when the
job is scheduled to run.
If the backup files are going to a \\share or a mapped drive (as opposed to
local drive), then you will need to modify the above (with respect to where
the tests and utilities are run).
Finally, inspection of the maintenance plan's history report might be
useful.
Thanks,
Bill Hollinshead
Microsoft, SQL Server
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Roger Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:045801c39db5$02521100$a601280a@.phx.gbl...
> We are using SQL Server 2000 with SP3 installed.
> In the database maintenance plan, we have chosen
> to "Remove files older than 1 week" for the production
> database.
> We would like to know does the setting mean that "SQL
> Server will remove backup files generated by the DB
> Maitenance Plan will be removed if it is older than 1
> week ?". This is because we find that there are some DB
> backups (Done in July last year) exist in that directory.
> Thanks|||Dear Tibor,
Thank you for your advice.
However, what I missed in last message is that -
Is it possible to make ad hoc backup of the production
database in the same directory where "Daily backup is
generated by the database maintenance plan that 'Remove
files older than 1 week' option is chosen for the
production database".
This is because if the "Database Maintenance Plan" only
remove backups generated by itself, it is perfect for us
to put ad hoc backup there as we don't want to create
another directory for holding ad hoc backup.
Thanks
Tuesday, March 20, 2012
Remote server backups to local drive?
Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>> No, I do not have direct access to perform a backup or copy the bak
>> files.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>>
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>> No, I do not have direct access to perform a backup or copy the bak
>> files.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>>
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>> No, I do not have direct access to perform a backup or copy the bak
>> files.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>>
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>> No, I do not have direct access to perform a backup or copy the bak
>> files.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>>
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Remote server backups to local drive?
Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Remote server backups to local drive?
Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.
ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>
|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>
|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>
|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>
|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.
ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>
|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>
|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>
|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>
|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Remote server
Hi,
I have created 1 sqls server as a remote server in another sql server, so I can execute backup jobs on the backup server from the production server.
This was all working ok, but now everytime the backup is called I get an error message saying login falied for 'sa'.
I haven't changed anything and the remote logins look like they are set up correctly.
Any advise would be appreciatedMy guess would be that you applied sp3, and when it "hardened" the sa password on your slave server, things went amok. Open Query Analyzer on your master, and attempt to log into your slave as sa. If that breaks, you'll need to find (or change) the sa password for your slave, then fix the problem(s) (there may be more than one) in the remote login definitions.
-PatP|||Hi,
Did not apply sp3? they were both applied to both the servers before this error occured.
this is the kind thing that has stopped working
Run on server 1 as a job
exec Server2.msdb.dbo.sp_start_job @.job_name='Restore = Load Alpha AM'
I have created 1 sqls server as a remote server in another sql server, so I can execute backup jobs on the backup server from the production server.
This was all working ok, but now everytime the backup is called I get an error message saying login falied for 'sa'.
I haven't changed anything and the remote logins look like they are set up correctly.
Any advise would be appreciatedMy guess would be that you applied sp3, and when it "hardened" the sa password on your slave server, things went amok. Open Query Analyzer on your master, and attempt to log into your slave as sa. If that breaks, you'll need to find (or change) the sa password for your slave, then fix the problem(s) (there may be more than one) in the remote login definitions.
-PatP|||Hi,
Did not apply sp3? they were both applied to both the servers before this error occured.
this is the kind thing that has stopped working
Run on server 1 as a job
exec Server2.msdb.dbo.sp_start_job @.job_name='Restore = Load Alpha AM'
Monday, March 12, 2012
Remote Restore via Linked Server
Hi, I'm initiating a restore via a linked server and an SQL Agent Job. The
job completes successfully in about 10 minutes, but the backup is left in a
loading state. This suggests that the connection timed out. Any thoughts
on how to make this more robust? (possibly start an SQL Agent job on the
remote server from the parent server')
Thanks
Bill"Bill Swartz" <swartz.bill@.gmail.com> wrote in message
news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
> The job completes successfully in about 10 minutes, but the backup is left
> in a loading state. This suggests that the connection timed out. Any
> thoughts on how to make this more robust? (possibly start an SQL Agent
> job on the remote server from the parent server')
>
That's what I would do.
David|||Answering my own question to some degree, initiating the remote procedure
via an SQL Agent job on the remote server works fine. (or in other words it
does not time out). But, it also flags the step on the host server
immediately as successful.
What I'm looking for is a way for the job to wait, or at least report the
status of the restore back to the host server.
Bill
"Bill Swartz" <swartz.bill@.gmail.com> wrote in message
news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
> The job completes successfully in about 10 minutes, but the backup is left
> in a loading state. This suggests that the connection timed out. Any
> thoughts on how to make this more robust? (possibly start an SQL Agent
> job on the remote server from the parent server')
> Thanks
> Bill
>|||This is a multi-part message in MIME format.
--050606090705070603040506
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Bill S wrote:
> Answering my own question to some degree, initiating the remote procedure
> via an SQL Agent job on the remote server works fine. (or in other words it
> does not time out). But, it also flags the step on the host server
> immediately as successful.
> What I'm looking for is a way for the job to wait, or at least report the
> status of the restore back to the host server.
> Bill
> "Bill Swartz" <swartz.bill@.gmail.com> wrote in message
> news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
>> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
>> The job completes successfully in about 10 minutes, but the backup is left
>> in a loading state. This suggests that the connection timed out. Any
>> thoughts on how to make this more robust? (possibly start an SQL Agent
>> job on the remote server from the parent server')
>> Thanks
>> Bill
>>
>
>
Hi
I've done a similar thing with a DTS package. In the package there's a
connection to the remote server and then a step that runs a restore on
that server. The package will not finish the execution until the restore
is done so that will give you what you want.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--050606090705070603040506
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Bill S wrote:
<blockquote cite="mid%237WfcfqrGHA.1140@.TK2MSFTNGP05.phx.gbl"
type="cite">
<pre wrap="">Answering my own question to some degree, initiating the remote procedure
via an SQL Agent job on the remote server works fine. (or in other words it
does not time out). But, it also flags the step on the host server
immediately as successful.
What I'm looking for is a way for the job to wait, or at least report the
status of the restore back to the host server.
Bill
"Bill Swartz" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:swartz.bill@.gmail.com"><swartz.bill@.gmail.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl">news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
The job completes successfully in about 10 minutes, but the backup is left
in a loading state. This suggests that the connection timed out. Any
thoughts on how to make this more robust? (possibly start an SQL Agent
job on the remote server from the parent server')
Thanks
Bill
</pre>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
<font size="-1"><font face="Arial">Hi<br>
<br>
I've done a similar thing with a DTS package. In the package there's a
connection to the remote server and then a step that runs a restore on
that server. The package will not finish the execution until the
restore is done so that will give you what you want.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--050606090705070603040506--
job completes successfully in about 10 minutes, but the backup is left in a
loading state. This suggests that the connection timed out. Any thoughts
on how to make this more robust? (possibly start an SQL Agent job on the
remote server from the parent server')
Thanks
Bill"Bill Swartz" <swartz.bill@.gmail.com> wrote in message
news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
> The job completes successfully in about 10 minutes, but the backup is left
> in a loading state. This suggests that the connection timed out. Any
> thoughts on how to make this more robust? (possibly start an SQL Agent
> job on the remote server from the parent server')
>
That's what I would do.
David|||Answering my own question to some degree, initiating the remote procedure
via an SQL Agent job on the remote server works fine. (or in other words it
does not time out). But, it also flags the step on the host server
immediately as successful.
What I'm looking for is a way for the job to wait, or at least report the
status of the restore back to the host server.
Bill
"Bill Swartz" <swartz.bill@.gmail.com> wrote in message
news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
> The job completes successfully in about 10 minutes, but the backup is left
> in a loading state. This suggests that the connection timed out. Any
> thoughts on how to make this more robust? (possibly start an SQL Agent
> job on the remote server from the parent server')
> Thanks
> Bill
>|||This is a multi-part message in MIME format.
--050606090705070603040506
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Bill S wrote:
> Answering my own question to some degree, initiating the remote procedure
> via an SQL Agent job on the remote server works fine. (or in other words it
> does not time out). But, it also flags the step on the host server
> immediately as successful.
> What I'm looking for is a way for the job to wait, or at least report the
> status of the restore back to the host server.
> Bill
> "Bill Swartz" <swartz.bill@.gmail.com> wrote in message
> news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
>> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
>> The job completes successfully in about 10 minutes, but the backup is left
>> in a loading state. This suggests that the connection timed out. Any
>> thoughts on how to make this more robust? (possibly start an SQL Agent
>> job on the remote server from the parent server')
>> Thanks
>> Bill
>>
>
>
Hi
I've done a similar thing with a DTS package. In the package there's a
connection to the remote server and then a step that runs a restore on
that server. The package will not finish the execution until the restore
is done so that will give you what you want.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--050606090705070603040506
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Bill S wrote:
<blockquote cite="mid%237WfcfqrGHA.1140@.TK2MSFTNGP05.phx.gbl"
type="cite">
<pre wrap="">Answering my own question to some degree, initiating the remote procedure
via an SQL Agent job on the remote server works fine. (or in other words it
does not time out). But, it also flags the step on the host server
immediately as successful.
What I'm looking for is a way for the job to wait, or at least report the
status of the restore back to the host server.
Bill
"Bill Swartz" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:swartz.bill@.gmail.com"><swartz.bill@.gmail.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl">news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
The job completes successfully in about 10 minutes, but the backup is left
in a loading state. This suggests that the connection timed out. Any
thoughts on how to make this more robust? (possibly start an SQL Agent
job on the remote server from the parent server')
Thanks
Bill
</pre>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
<font size="-1"><font face="Arial">Hi<br>
<br>
I've done a similar thing with a DTS package. In the package there's a
connection to the remote server and then a step that runs a restore on
that server. The package will not finish the execution until the
restore is done so that will give you what you want.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--050606090705070603040506--
Remote Restore via Linked Server
Hi, I'm initiating a restore via a linked server and an SQL Agent Job. The
job completes successfully in about 10 minutes, but the backup is left in a
loading state. This suggests that the connection timed out. Any thoughts
on how to make this more robust? (possibly start an SQL Agent job on the
remote server from the parent server')
Thanks
Bill"Bill Swartz" <swartz.bill@.gmail.com> wrote in message
news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
> The job completes successfully in about 10 minutes, but the backup is left
> in a loading state. This suggests that the connection timed out. Any
> thoughts on how to make this more robust? (possibly start an SQL Agent
> job on the remote server from the parent server')
>
That's what I would do.
David|||Answering my own question to some degree, initiating the remote procedure
via an SQL Agent job on the remote server works fine. (or in other words it
does not time out). But, it also flags the step on the host server
immediately as successful.
What I'm looking for is a way for the job to wait, or at least report the
status of the restore back to the host server.
Bill
"Bill Swartz" <swartz.bill@.gmail.com> wrote in message
news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
> The job completes successfully in about 10 minutes, but the backup is left
> in a loading state. This suggests that the connection timed out. Any
> thoughts on how to make this more robust? (possibly start an SQL Agent
> job on the remote server from the parent server')
> Thanks
> Bill
>|||Bill S wrote:
> Answering my own question to some degree, initiating the remote procedure
> via an SQL Agent job on the remote server works fine. (or in other words
it
> does not time out). But, it also flags the step on the host server
> immediately as successful.
> What I'm looking for is a way for the job to wait, or at least report the
> status of the restore back to the host server.
> Bill
> "Bill Swartz" <swartz.bill@.gmail.com> wrote in message
> news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
>
>
>
Hi
I've done a similar thing with a DTS package. In the package there's a
connection to the remote server and then a step that runs a restore on
that server. The package will not finish the execution until the restore
is done so that will give you what you want.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator
job completes successfully in about 10 minutes, but the backup is left in a
loading state. This suggests that the connection timed out. Any thoughts
on how to make this more robust? (possibly start an SQL Agent job on the
remote server from the parent server')
Thanks
Bill"Bill Swartz" <swartz.bill@.gmail.com> wrote in message
news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
> The job completes successfully in about 10 minutes, but the backup is left
> in a loading state. This suggests that the connection timed out. Any
> thoughts on how to make this more robust? (possibly start an SQL Agent
> job on the remote server from the parent server')
>
That's what I would do.
David|||Answering my own question to some degree, initiating the remote procedure
via an SQL Agent job on the remote server works fine. (or in other words it
does not time out). But, it also flags the step on the host server
immediately as successful.
What I'm looking for is a way for the job to wait, or at least report the
status of the restore back to the host server.
Bill
"Bill Swartz" <swartz.bill@.gmail.com> wrote in message
news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm initiating a restore via a linked server and an SQL Agent Job.
> The job completes successfully in about 10 minutes, but the backup is left
> in a loading state. This suggests that the connection timed out. Any
> thoughts on how to make this more robust? (possibly start an SQL Agent
> job on the remote server from the parent server')
> Thanks
> Bill
>|||Bill S wrote:
> Answering my own question to some degree, initiating the remote procedure
> via an SQL Agent job on the remote server works fine. (or in other words
it
> does not time out). But, it also flags the step on the host server
> immediately as successful.
> What I'm looking for is a way for the job to wait, or at least report the
> status of the restore back to the host server.
> Bill
> "Bill Swartz" <swartz.bill@.gmail.com> wrote in message
> news:ueVmqUqrGHA.1732@.TK2MSFTNGP03.phx.gbl...
>
>
>
Hi
I've done a similar thing with a DTS package. In the package there's a
connection to the remote server and then a step that runs a restore on
that server. The package will not finish the execution until the restore
is done so that will give you what you want.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator
Wednesday, March 7, 2012
Remote Database backup/restore
Anyone know if this can be done over TCP/IP connection?
Thanks in advance..
-BBHi,
Yes, You can do that. All you have to do is , create a Alias for the SQL
server using TCP/IP protocol, Ip address and Port number.
Using that Alias name register the SQL server in enterprise manager or use
Query Analyzer to connect.
After that you could run the BACKUP DATABASE command to backup and RESTORE
DATABASE command to restore the database.
To backup the file remotely or restore the file from remote locaton you have
to start the SQL Server service
using an Domain OS user which got write access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Anyone know if this can be done over TCP/IP connection?
> Thanks in advance..
> -BB
>|||Hi Hari,
I had gotten this already. So the only file systems that can EVER be seen
are the ones available to the Server .. no matter where you execute the
BACKUP from? For example if I want to execute the backup from a remote
site, and put the dump file on client that is executing the BACKUP, then I
MUST have a network share enabled on the remote client computer?
Many thnx again,
-BB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, You can do that. All you have to do is , create a Alias for the SQL
> server using TCP/IP protocol, Ip address and Port number.
> Using that Alias name register the SQL server in enterprise manager or use
> Query Analyzer to connect.
> After that you could run the BACKUP DATABASE command to backup and RESTORE
> DATABASE command to restore the database.
> To backup the file remotely or restore the file from remote locaton you
have
> to start the SQL Server service
> using an Domain OS user which got write access to the remote share.
> So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
sercice--
> Double click and select the "Log on" option.
> There you give a Valid Domain OS user and password to start the service.
Now
> stop and start the MSSQL Serevr service.
> Note: That domain user should have previlages in the remote share to write
> the file as well as prev. to start the SQL server.
> After this you try to execute the Backup database command in Query
> Analyzer:-
>
> Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> init ( With init will overwrite the backup file every time)
> Thanks
> Hari
> MCDBA
>
>
> Thanks
> Hari
> MCDBA
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > Anyone know if this can be done over TCP/IP connection?
> >
> > Thanks in advance..
> >
> > -BB
> >
> >
>|||Correct. SQL Server does the backup, not the client from where you run the client app to send the BACKUP
commend to SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> I had gotten this already. So the only file systems that can EVER be seen
> are the ones available to the Server .. no matter where you execute the
> BACKUP from? For example if I want to execute the backup from a remote
> site, and put the dump file on client that is executing the BACKUP, then I
> MUST have a network share enabled on the remote client computer?
> Many thnx again,
> -BB
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Yes, You can do that. All you have to do is , create a Alias for the SQL
> > server using TCP/IP protocol, Ip address and Port number.
> > Using that Alias name register the SQL server in enterprise manager or use
> > Query Analyzer to connect.
> >
> > After that you could run the BACKUP DATABASE command to backup and RESTORE
> > DATABASE command to restore the database.
> >
> > To backup the file remotely or restore the file from remote locaton you
> have
> > to start the SQL Server service
> > using an Domain OS user which got write access to the remote share.
> >
> > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
> sercice--
> > Double click and select the "Log on" option.
> > There you give a Valid Domain OS user and password to start the service.
> Now
> > stop and start the MSSQL Serevr service.
> >
> > Note: That domain user should have previlages in the remote share to write
> > the file as well as prev. to start the SQL server.
> >
> > After this you try to execute the Backup database command in Query
> > Analyzer:-
> >
> >
> > Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> > init ( With init will overwrite the backup file every time)
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> > news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > > Anyone know if this can be done over TCP/IP connection?
> > >
> > > Thanks in advance..
> > >
> > > -BB
> > >
> > >
> >
> >
>|||ok thx
-BB
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u9njHXseEHA.396@.TK2MSFTNGP12.phx.gbl...
> Correct. SQL Server does the backup, not the client from where you run the
client app to send the BACKUP
> commend to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > Hi Hari,
> >
> > I had gotten this already. So the only file systems that can EVER be
seen
> > are the ones available to the Server .. no matter where you execute the
> > BACKUP from? For example if I want to execute the backup from a
remote
> > site, and put the dump file on client that is executing the BACKUP, then
I
> > MUST have a network share enabled on the remote client computer?
> >
> > Many thnx again,
> >
> > -BB
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> > news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > Yes, You can do that. All you have to do is , create a Alias for the
SQL
> > > server using TCP/IP protocol, Ip address and Port number.
> > > Using that Alias name register the SQL server in enterprise manager or
use
> > > Query Analyzer to connect.
> > >
> > > After that you could run the BACKUP DATABASE command to backup and
RESTORE
> > > DATABASE command to restore the database.
> > >
> > > To backup the file remotely or restore the file from remote locaton
you
> > have
> > > to start the SQL Server service
> > > using an Domain OS user which got write access to the remote share.
> > >
> > > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
> > sercice--
> > > Double click and select the "Log on" option.
> > > There you give a Valid Domain OS user and password to start the
service.
> > Now
> > > stop and start the MSSQL Serevr service.
> > >
> > > Note: That domain user should have previlages in the remote share to
write
> > > the file as well as prev. to start the SQL server.
> > >
> > > After this you try to execute the Backup database command in Query
> > > Analyzer:-
> > >
> > >
> > > Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat'
with
> > > init ( With init will overwrite the backup file every time)
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> > > news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > > > Anyone know if this can be done over TCP/IP connection?
> > > >
> > > > Thanks in advance..
> > > >
> > > > -BB
> > > >
> > > >
> > >
> > >
> >
> >
>
Thanks in advance..
-BBHi,
Yes, You can do that. All you have to do is , create a Alias for the SQL
server using TCP/IP protocol, Ip address and Port number.
Using that Alias name register the SQL server in enterprise manager or use
Query Analyzer to connect.
After that you could run the BACKUP DATABASE command to backup and RESTORE
DATABASE command to restore the database.
To backup the file remotely or restore the file from remote locaton you have
to start the SQL Server service
using an Domain OS user which got write access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Anyone know if this can be done over TCP/IP connection?
> Thanks in advance..
> -BB
>|||Hi Hari,
I had gotten this already. So the only file systems that can EVER be seen
are the ones available to the Server .. no matter where you execute the
BACKUP from? For example if I want to execute the backup from a remote
site, and put the dump file on client that is executing the BACKUP, then I
MUST have a network share enabled on the remote client computer?
Many thnx again,
-BB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, You can do that. All you have to do is , create a Alias for the SQL
> server using TCP/IP protocol, Ip address and Port number.
> Using that Alias name register the SQL server in enterprise manager or use
> Query Analyzer to connect.
> After that you could run the BACKUP DATABASE command to backup and RESTORE
> DATABASE command to restore the database.
> To backup the file remotely or restore the file from remote locaton you
have
> to start the SQL Server service
> using an Domain OS user which got write access to the remote share.
> So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
sercice--
> Double click and select the "Log on" option.
> There you give a Valid Domain OS user and password to start the service.
Now
> stop and start the MSSQL Serevr service.
> Note: That domain user should have previlages in the remote share to write
> the file as well as prev. to start the SQL server.
> After this you try to execute the Backup database command in Query
> Analyzer:-
>
> Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> init ( With init will overwrite the backup file every time)
> Thanks
> Hari
> MCDBA
>
>
> Thanks
> Hari
> MCDBA
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > Anyone know if this can be done over TCP/IP connection?
> >
> > Thanks in advance..
> >
> > -BB
> >
> >
>|||Correct. SQL Server does the backup, not the client from where you run the client app to send the BACKUP
commend to SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> I had gotten this already. So the only file systems that can EVER be seen
> are the ones available to the Server .. no matter where you execute the
> BACKUP from? For example if I want to execute the backup from a remote
> site, and put the dump file on client that is executing the BACKUP, then I
> MUST have a network share enabled on the remote client computer?
> Many thnx again,
> -BB
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Yes, You can do that. All you have to do is , create a Alias for the SQL
> > server using TCP/IP protocol, Ip address and Port number.
> > Using that Alias name register the SQL server in enterprise manager or use
> > Query Analyzer to connect.
> >
> > After that you could run the BACKUP DATABASE command to backup and RESTORE
> > DATABASE command to restore the database.
> >
> > To backup the file remotely or restore the file from remote locaton you
> have
> > to start the SQL Server service
> > using an Domain OS user which got write access to the remote share.
> >
> > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
> sercice--
> > Double click and select the "Log on" option.
> > There you give a Valid Domain OS user and password to start the service.
> Now
> > stop and start the MSSQL Serevr service.
> >
> > Note: That domain user should have previlages in the remote share to write
> > the file as well as prev. to start the SQL server.
> >
> > After this you try to execute the Backup database command in Query
> > Analyzer:-
> >
> >
> > Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> > init ( With init will overwrite the backup file every time)
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> > news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > > Anyone know if this can be done over TCP/IP connection?
> > >
> > > Thanks in advance..
> > >
> > > -BB
> > >
> > >
> >
> >
>|||ok thx
-BB
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u9njHXseEHA.396@.TK2MSFTNGP12.phx.gbl...
> Correct. SQL Server does the backup, not the client from where you run the
client app to send the BACKUP
> commend to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > Hi Hari,
> >
> > I had gotten this already. So the only file systems that can EVER be
seen
> > are the ones available to the Server .. no matter where you execute the
> > BACKUP from? For example if I want to execute the backup from a
remote
> > site, and put the dump file on client that is executing the BACKUP, then
I
> > MUST have a network share enabled on the remote client computer?
> >
> > Many thnx again,
> >
> > -BB
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> > news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > Yes, You can do that. All you have to do is , create a Alias for the
SQL
> > > server using TCP/IP protocol, Ip address and Port number.
> > > Using that Alias name register the SQL server in enterprise manager or
use
> > > Query Analyzer to connect.
> > >
> > > After that you could run the BACKUP DATABASE command to backup and
RESTORE
> > > DATABASE command to restore the database.
> > >
> > > To backup the file remotely or restore the file from remote locaton
you
> > have
> > > to start the SQL Server service
> > > using an Domain OS user which got write access to the remote share.
> > >
> > > So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
> > sercice--
> > > Double click and select the "Log on" option.
> > > There you give a Valid Domain OS user and password to start the
service.
> > Now
> > > stop and start the MSSQL Serevr service.
> > >
> > > Note: That domain user should have previlages in the remote share to
write
> > > the file as well as prev. to start the SQL server.
> > >
> > > After this you try to execute the Backup database command in Query
> > > Analyzer:-
> > >
> > >
> > > Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat'
with
> > > init ( With init will overwrite the backup file every time)
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> > > news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> > > > Anyone know if this can be done over TCP/IP connection?
> > > >
> > > > Thanks in advance..
> > > >
> > > > -BB
> > > >
> > > >
> > >
> > >
> >
> >
>
Remote Database backup/restore
Anyone know if this can be done over TCP/IP connection?
Thanks in advance..
-BBHi,
Yes, You can do that. All you have to do is , create a Alias for the SQL
server using TCP/IP protocol, Ip address and Port number.
Using that Alias name register the SQL server in enterprise manager or use
Query Analyzer to connect.
After that you could run the BACKUP DATABASE command to backup and RESTORE
DATABASE command to restore the database.
To backup the file remotely or restore the file from remote locaton you have
to start the SQL Server service
using an Domain OS user which got write access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Anyone know if this can be done over TCP/IP connection?
> Thanks in advance..
> -BB
>|||Hi Hari,
I had gotten this already. So the only file systems that can EVER be seen
are the ones available to the Server .. no matter where you execute the
BACKUP from? For example if I want to execute the backup from a remote
site, and put the dump file on client that is executing the BACKUP, then I
MUST have a network share enabled on the remote client computer?
Many thnx again,
-BB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, You can do that. All you have to do is , create a Alias for the SQL
> server using TCP/IP protocol, Ip address and Port number.
> Using that Alias name register the SQL server in enterprise manager or use
> Query Analyzer to connect.
> After that you could run the BACKUP DATABASE command to backup and RESTORE
> DATABASE command to restore the database.
> To backup the file remotely or restore the file from remote locaton you
have
> to start the SQL Server service
> using an Domain OS user which got write access to the remote share.
> So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
sercice--
> Double click and select the "Log on" option.
> There you give a Valid Domain OS user and password to start the service.
Now
> stop and start the MSSQL Serevr service.
> Note: That domain user should have previlages in the remote share to write
> the file as well as prev. to start the SQL server.
> After this you try to execute the Backup database command in Query
> Analyzer:-
>
> Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> init ( With init will overwrite the backup file every time)
> Thanks
> Hari
> MCDBA
>
>
> Thanks
> Hari
> MCDBA
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
>|||Correct. SQL Server does the backup, not the client from where you run the c
lient app to send the BACKUP
commend to SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:Ox0$yQseEHA.1356@.TK2MSFTNGP09
.phx.gbl...
> Hi Hari,
> I had gotten this already. So the only file systems that can EVER be see
n
> are the ones available to the Server .. no matter where you execute the
> BACKUP from? For example if I want to execute the backup from a remote
> site, and put the dump file on client that is executing the BACKUP, then I
> MUST have a network share enabled on the remote client computer?
> Many thnx again,
> -BB
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> have
> sercice--
> Now
>|||ok thx
-BB
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u9njHXseEHA.396@.TK2MSFTNGP12.phx.gbl...
> Correct. SQL Server does the backup, not the client from where you run the
client app to send the BACKUP
> commend to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
seen[vbcol=seagreen]
remote[vbcol=seagreen]
I[vbcol=seagreen]
SQL[vbcol=seagreen]
use[vbcol=seagreen]
RESTORE[vbcol=seagreen]
you[vbcol=seagreen]
service.[vbcol=seagreen]
write[vbcol=seagreen]
with[vbcol=seagreen]
>
Thanks in advance..
-BBHi,
Yes, You can do that. All you have to do is , create a Alias for the SQL
server using TCP/IP protocol, Ip address and Port number.
Using that Alias name register the SQL server in enterprise manager or use
Query Analyzer to connect.
After that you could run the BACKUP DATABASE command to backup and RESTORE
DATABASE command to restore the database.
To backup the file remotely or restore the file from remote locaton you have
to start the SQL Server service
using an Domain OS user which got write access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Anyone know if this can be done over TCP/IP connection?
> Thanks in advance..
> -BB
>|||Hi Hari,
I had gotten this already. So the only file systems that can EVER be seen
are the ones available to the Server .. no matter where you execute the
BACKUP from? For example if I want to execute the backup from a remote
site, and put the dump file on client that is executing the BACKUP, then I
MUST have a network share enabled on the remote client computer?
Many thnx again,
-BB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, You can do that. All you have to do is , create a Alias for the SQL
> server using TCP/IP protocol, Ip address and Port number.
> Using that Alias name register the SQL server in enterprise manager or use
> Query Analyzer to connect.
> After that you could run the BACKUP DATABASE command to backup and RESTORE
> DATABASE command to restore the database.
> To backup the file remotely or restore the file from remote locaton you
have
> to start the SQL Server service
> using an Domain OS user which got write access to the remote share.
> So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
sercice--
> Double click and select the "Log on" option.
> There you give a Valid Domain OS user and password to start the service.
Now
> stop and start the MSSQL Serevr service.
> Note: That domain user should have previlages in the remote share to write
> the file as well as prev. to start the SQL server.
> After this you try to execute the Backup database command in Query
> Analyzer:-
>
> Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> init ( With init will overwrite the backup file every time)
> Thanks
> Hari
> MCDBA
>
>
> Thanks
> Hari
> MCDBA
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
>|||Correct. SQL Server does the backup, not the client from where you run the c
lient app to send the BACKUP
commend to SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:Ox0$yQseEHA.1356@.TK2MSFTNGP09
.phx.gbl...
> Hi Hari,
> I had gotten this already. So the only file systems that can EVER be see
n
> are the ones available to the Server .. no matter where you execute the
> BACKUP from? For example if I want to execute the backup from a remote
> site, and put the dump file on client that is executing the BACKUP, then I
> MUST have a network share enabled on the remote client computer?
> Many thnx again,
> -BB
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> have
> sercice--
> Now
>|||ok thx
-BB
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u9njHXseEHA.396@.TK2MSFTNGP12.phx.gbl...
> Correct. SQL Server does the backup, not the client from where you run the
client app to send the BACKUP
> commend to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
seen[vbcol=seagreen]
remote[vbcol=seagreen]
I[vbcol=seagreen]
SQL[vbcol=seagreen]
use[vbcol=seagreen]
RESTORE[vbcol=seagreen]
you[vbcol=seagreen]
service.[vbcol=seagreen]
write[vbcol=seagreen]
with[vbcol=seagreen]
>
Remote Database backup/restore
Anyone know if this can be done over TCP/IP connection?
Thanks in advance..
-BB
Hi,
Yes, You can do that. All you have to do is , create a Alias for the SQL
server using TCP/IP protocol, Ip address and Port number.
Using that Alias name register the SQL server in enterprise manager or use
Query Analyzer to connect.
After that you could run the BACKUP DATABASE command to backup and RESTORE
DATABASE command to restore the database.
To backup the file remotely or restore the file from remote locaton you have
to start the SQL Server service
using an Domain OS user which got write access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Anyone know if this can be done over TCP/IP connection?
> Thanks in advance..
> -BB
>
|||Hi Hari,
I had gotten this already. So the only file systems that can EVER be seen
are the ones available to the Server .. no matter where you execute the
BACKUP from? For example if I want to execute the backup from a remote
site, and put the dump file on client that is executing the BACKUP, then I
MUST have a network share enabled on the remote client computer?
Many thnx again,
-BB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, You can do that. All you have to do is , create a Alias for the SQL
> server using TCP/IP protocol, Ip address and Port number.
> Using that Alias name register the SQL server in enterprise manager or use
> Query Analyzer to connect.
> After that you could run the BACKUP DATABASE command to backup and RESTORE
> DATABASE command to restore the database.
> To backup the file remotely or restore the file from remote locaton you
have
> to start the SQL Server service
> using an Domain OS user which got write access to the remote share.
> So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
sercice--
> Double click and select the "Log on" option.
> There you give a Valid Domain OS user and password to start the service.
Now
> stop and start the MSSQL Serevr service.
> Note: That domain user should have previlages in the remote share to write
> the file as well as prev. to start the SQL server.
> After this you try to execute the Backup database command in Query
> Analyzer:-
>
> Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> init ( With init will overwrite the backup file every time)
> Thanks
> Hari
> MCDBA
>
>
> Thanks
> Hari
> MCDBA
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
>
|||Correct. SQL Server does the backup, not the client from where you run the client app to send the BACKUP
commend to SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> I had gotten this already. So the only file systems that can EVER be seen
> are the ones available to the Server .. no matter where you execute the
> BACKUP from? For example if I want to execute the backup from a remote
> site, and put the dump file on client that is executing the BACKUP, then I
> MUST have a network share enabled on the remote client computer?
> Many thnx again,
> -BB
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> have
> sercice--
> Now
>
|||ok thx
-BB
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u9njHXseEHA.396@.TK2MSFTNGP12.phx.gbl...
> Correct. SQL Server does the backup, not the client from where you run the
client app to send the BACKUP
> commend to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
seen[vbcol=seagreen]
remote[vbcol=seagreen]
I[vbcol=seagreen]
SQL[vbcol=seagreen]
use[vbcol=seagreen]
RESTORE[vbcol=seagreen]
you[vbcol=seagreen]
service.[vbcol=seagreen]
write[vbcol=seagreen]
with
>
Thanks in advance..
-BB
Hi,
Yes, You can do that. All you have to do is , create a Alias for the SQL
server using TCP/IP protocol, Ip address and Port number.
Using that Alias name register the SQL server in enterprise manager or use
Query Analyzer to connect.
After that you could run the BACKUP DATABASE command to backup and RESTORE
DATABASE command to restore the database.
To backup the file remotely or restore the file from remote locaton you have
to start the SQL Server service
using an Domain OS user which got write access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
MCDBA
Thanks
Hari
MCDBA
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Anyone know if this can be done over TCP/IP connection?
> Thanks in advance..
> -BB
>
|||Hi Hari,
I had gotten this already. So the only file systems that can EVER be seen
are the ones available to the Server .. no matter where you execute the
BACKUP from? For example if I want to execute the backup from a remote
site, and put the dump file on client that is executing the BACKUP, then I
MUST have a network share enabled on the remote client computer?
Many thnx again,
-BB
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, You can do that. All you have to do is , create a Alias for the SQL
> server using TCP/IP protocol, Ip address and Port number.
> Using that Alias name register the SQL server in enterprise manager or use
> Query Analyzer to connect.
> After that you could run the BACKUP DATABASE command to backup and RESTORE
> DATABASE command to restore the database.
> To backup the file remotely or restore the file from remote locaton you
have
> to start the SQL Server service
> using an Domain OS user which got write access to the remote share.
> So go to Control Panel -- Admin Tools -- Services -- MSSQL Server
sercice--
> Double click and select the "Log on" option.
> There you give a Valid Domain OS user and password to start the service.
Now
> stop and start the MSSQL Serevr service.
> Note: That domain user should have previlages in the remote share to write
> the file as well as prev. to start the SQL server.
> After this you try to execute the Backup database command in Query
> Analyzer:-
>
> Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
> init ( With init will overwrite the backup file every time)
> Thanks
> Hari
> MCDBA
>
>
> Thanks
> Hari
> MCDBA
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
> news:OlznK7qeEHA.3916@.TK2MSFTNGP11.phx.gbl...
>
|||Correct. SQL Server does the backup, not the client from where you run the client app to send the BACKUP
commend to SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> I had gotten this already. So the only file systems that can EVER be seen
> are the ones available to the Server .. no matter where you execute the
> BACKUP from? For example if I want to execute the backup from a remote
> site, and put the dump file on client that is executing the BACKUP, then I
> MUST have a network share enabled on the remote client computer?
> Many thnx again,
> -BB
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWJgEreEHA.556@.tk2msftngp13.phx.gbl...
> have
> sercice--
> Now
>
|||ok thx
-BB
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u9njHXseEHA.396@.TK2MSFTNGP12.phx.gbl...
> Correct. SQL Server does the backup, not the client from where you run the
client app to send the BACKUP
> commend to SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Brian Burgess" <bburgess66@.hotmail.com> wrote in message
news:Ox0$yQseEHA.1356@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
seen[vbcol=seagreen]
remote[vbcol=seagreen]
I[vbcol=seagreen]
SQL[vbcol=seagreen]
use[vbcol=seagreen]
RESTORE[vbcol=seagreen]
you[vbcol=seagreen]
service.[vbcol=seagreen]
write[vbcol=seagreen]
with
>
Saturday, February 25, 2012
Remote creation of a Maintenance plan
I'm trying to remotely create a maintenance plan using the management studio in order to backup databases. I get the following error.
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
TITLE: Maintenance Plan Wizard Progress
Create maintenance plan failed.
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'. (Microsoft.SqlServer.MaintenancePlanTasks)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The specified '@.subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
The server doesn't have the Management studio client installed so I can't create the maintenance plan locally. If I install just the Management studio will the data currently in the server be effected? Any solution to the remote problem?
Thanks,
Neil
SSIS(SQL Server integration services) need to be installed along with the server, for executing maintenace plans successfully.
For SP1, the current plan is either SSIS or tools installed on the server box would address this issue.
Gops Dwarak
Remote creation of a Maintenance plan
I'm trying to remotely create a maintenance plan using the management studio in order to backup databases. I get the following error.
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
TITLE: Maintenance Plan Wizard Progress
Create maintenance plan failed.
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'. (Microsoft.SqlServer.MaintenancePlanTasks)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The specified '@.subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
The server doesn't have the Management studio client installed so I can't create the maintenance plan locally. If I install just the Management studio will the data currently in the server be effected? Any solution to the remote problem?
Thanks,
Neil
SSIS(SQL Server integration services) need to be installed along with the server, for executing maintenace plans successfully.
For SP1, the current plan is either SSIS or tools installed on the server box would address this issue.
Gops Dwarak
Subscribe to:
Posts (Atom)