Showing posts with label locations. Show all posts
Showing posts with label locations. Show all posts

Tuesday, March 20, 2012

Bandwidth betwee Synchronous connection

I am looking into the different options for redunancy between locations. We
currently have a 6mb P2P between the locations. Which would be better
Database mirroring or Database replication?
Mirroring means that your "subscriber/destination database/mirror" is
inaccessible. Replication means that the subscriber database is accessible
and that you can select which tables you want to replicate.
It really depends on what you are trying to do.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Cindy" <Cindy@.discussions.microsoft.com> wrote in message
news:4A02CE96-43A5-4296-9A79-98DF75684C44@.microsoft.com...
>I am looking into the different options for redunancy between locations.
>We
> currently have a 6mb P2P between the locations. Which would be better
> Database mirroring or Database replication?
|||Our situation
Moved Database server to CoLo for Business Continuity. Main database will
reside on SAN. SLO requires offsite storage of backups and monthly copies
offsite.
I am looking for a live backup of the database incase of hardware failure on
SQL server or SAN. I am also looking at managing backup to tape at Corporate
Office where Mirror/Replication server will reside.
What are your suggestions?
"Hilary Cotter" wrote:

> Mirroring means that your "subscriber/destination database/mirror" is
> inaccessible. Replication means that the subscriber database is accessible
> and that you can select which tables you want to replicate.
> It really depends on what you are trying to do.
> --
> http://www.zetainteractive.com - Shift Happens!
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Cindy" <Cindy@.discussions.microsoft.com> wrote in message
> news:4A02CE96-43A5-4296-9A79-98DF75684C44@.microsoft.com...
>
>

Sunday, March 11, 2012

Backward Coompatibility

We have two different machines in different locations running SQL2000. One was upgraded to SQL2005. The problem is we can't upgrade the other at the moment cause it is running SBS2003 (requires alot more planning), But we would like to get information from the computer running SQL2005. Is there a patch that can be obtained so that we can open the database created using SQL2005 in SQL2000? We desperately need the database and upgrading to SQL2005 with SBS2003 is not straight forward.
Database files or backups created in SQL Server 2005 cannot be opened using SQL Server 2000. YOu sure can connect to the SQL Server 2005 server and get data but you are not able to use the physical files for restore or attaching.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||If you have the Sql2000 backup in tape \ disk before upgrading. Use the backup and restore the db in Sql2000, Use Import\Export to move all the data's from Sql2005 to Sql2000 for that db. Since you don't have any option for using Sql2005 physical or backup files in sql2000.

Sunday, February 12, 2012

Backup Transaction Log to 2 different location

hi,
is there a possibility do backup the transaction log to 2 different
locations, and to handle them separatly when restoring a database?
The thing i want to do is, to be able to restore the database on 2
different location without doing logshipping.
thx for your help.Hi
No. After the backup, do a XCOPY to the alternative location.
Regards
Mike
"Donald" wrote:
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
>|||When I've done this I've always implemented it as an external app (VB
based). Not too hard to do.
"Donald" <martin.ha@.gmx.net> wrote in message
news:enCcG$QDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.

backup to two different locations

Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? ThanksI do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
--
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/productinfo/top30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks

backup to two different locations

Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? Thanks
I do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks

backup to two different locations

Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? Thanks
I do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/p...30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks

backup to two different locations

Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? ThanksI do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/...p30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks

Friday, February 10, 2012

Backup to multiple locations

I currently have a database backing up to a file, every
day a new file is created and anything older than 2 weeks
is deleted. We then use the replace command to copy the
directory to another server.
We are having problems with the deleted file on the SQL
server not being deleted on the other server. Does
anyone know an easy way to do this? Or is it possible to
back up to two locations at once?
Thanks in advance,
Stevesounds like the acct used for SQL services doesn't have permission to delete
fiels on the other servers.
"steve" <anonymous@.discussions.microsoft.com> wrote in message
news:105601c3a248$7bfd2ac0$a001280a@.phx.gbl...
> I currently have a database backing up to a file, every
> day a new file is created and anything older than 2 weeks
> is deleted. We then use the replace command to copy the
> directory to another server.
> We are having problems with the deleted file on the SQL
> server not being deleted on the other server. Does
> anyone know an easy way to do this? Or is it possible to
> back up to two locations at once?
> Thanks in advance,
> Steve|||That is what I originally thought but I am running it as
a domain admin (full control) and am still unable to get
the deleted files to delete from the second server.
Any other ideas?
Steve
>--Original Message--
>sounds like the acct used for SQL services doesn't have
permission to delete
>fiels on the other servers.
>
>"steve" <anonymous@.discussions.microsoft.com> wrote in
message
>news:105601c3a248$7bfd2ac0$a001280a@.phx.gbl...
>> I currently have a database backing up to a file, every
>> day a new file is created and anything older than 2
weeks
>> is deleted. We then use the replace command to copy
the
>> directory to another server.
>> We are having problems with the deleted file on the SQL
>> server not being deleted on the other server. Does
>> anyone know an easy way to do this? Or is it possible
to
>> back up to two locations at once?
>> Thanks in advance,
>> Steve
>
>.|||The permissions may have been the problem afterall. For
some reason the replace command is now working and the
deleted files are being removed. It is very strange.
Thanks for your help.
Steve
>--Original Message--
>sounds like the acct used for SQL services doesn't have
permission to delete
>fiels on the other servers.
>
>"steve" <anonymous@.discussions.microsoft.com> wrote in
message
>news:105601c3a248$7bfd2ac0$a001280a@.phx.gbl...
>> I currently have a database backing up to a file, every
>> day a new file is created and anything older than 2
weeks
>> is deleted. We then use the replace command to copy
the
>> directory to another server.
>> We are having problems with the deleted file on the SQL
>> server not being deleted on the other server. Does
>> anyone know an easy way to do this? Or is it possible
to
>> back up to two locations at once?
>> Thanks in advance,
>> Steve
>
>.
>