hide system tables: backup

Showing posts with label backup. Show all posts

Monday, March 26, 2012

How to initialize pull transactional subscription with attaching of a database

What do I need to do to initialize pull transactional subscription with attaching of a database? It defers from initializing from backup.

Solved.

How to initialize pull transactional subscription with attaching of a database

What do I need to do to initialize pull transactional subscription with attaching of a database? It defers from initializing from backup.

Solved.

Wednesday, March 21, 2012

How to include more databases in DB Maintenance Plan ?

Hi,
I have created a DB maintenance plan to backup a production database daily.
There is a request to include 2 more databases to be included in the
maintenance plan. I have checked the maintenance plan but I am not able to
work out how to include 2 more databases.
Is it possible to give me some advice ?
ThanksPeter
Right Click on MP and then Properties . Add more user databases. Is that
what you mean?
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OZusmMoIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I have created a DB maintenance plan to backup a production database
> daily.
> There is a request to include 2 more databases to be included in the
> maintenance plan. I have checked the maintenance plan but I am not able
> to work out how to include 2 more databases.
> Is it possible to give me some advice ?
> Thanks
>|||Yes.
Peter
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O8m1RToIHHA.780@.TK2MSFTNGP03.phx.gbl...
> Peter
> Right Click on MP and then Properties . Add more user databases. Is that
> what you mean?
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:OZusmMoIHHA.2456@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> I have created a DB maintenance plan to backup a production database
>> daily.
>> There is a request to include 2 more databases to be included in the
>> maintenance plan. I have checked the maintenance plan but I am not able
>> to work out how to include 2 more databases.
>> Is it possible to give me some advice ?
>> Thanks
>

How to include more databases in DB Maintenance Plan ?

How to include more databases in DB Mainteance Plan for SQL Server 2005

Hi,
I have created a DB maintenance plan by using wizard to backup a production
database daily.
There is a request to include 2 more databases to be included in the
maintenance plan. I select the maintenance plan and press "Modify" but I am
not able to work out how to include 2 more databases. Besides, it appears
that both transaction log & database backup are not deleted since the plan
is executed, is there something wrong ?
Is it possible to give me some advice ?
ThanksPeter
You asked the question yesterday and I gave you the answer. Don't you
rememner that?
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:u01Fh30IHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have created a DB maintenance plan by using wizard to backup a
> production database daily.
> There is a request to include 2 more databases to be included in the
> maintenance plan. I select the maintenance plan and press "Modify" but I
> am not able to work out how to include 2 more databases. Besides, it
> appears that both transaction log & database backup are not deleted since
> the plan is executed, is there something wrong ?
> Is it possible to give me some advice ?
> Thanks
>|||> There is a request to include 2 more databases to be included in the maintenance plan. I select
> the maintenance plan and press "Modify" but I am not able to work out how to include 2 more
> databases.
You need to add the databases to the backup task inside the plan. Right-lock the backup task, select
"Edit..." and in the "Databases:" drop.down you select the databases you want to include.
> Besides, it appears that both transaction log & database backup are not deleted since the plan is
> executed, is there something wrong ?
Add a "Maintenance Cleanup Task" to the plan.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:u01Fh30IHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have created a DB maintenance plan by using wizard to backup a production database daily.
> There is a request to include 2 more databases to be included in the maintenance plan. I select
> the maintenance plan and press "Modify" but I am not able to work out how to include 2 more
> databases. Besides, it appears that both transaction log & database backup are not deleted since
> the plan is executed, is there something wrong ?
> Is it possible to give me some advice ?
> Thanks
>|||Dear Uri,
I forget to mention that it is SQL Server 2005 yesterday. In this way, your
advice is applicable for SQL Server 2000.
Thanks
Peter
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uEfBDB1IHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Peter
> You asked the question yesterday and I gave you the answer. Don't you
> rememner that?
>
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:u01Fh30IHHA.4712@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I have created a DB maintenance plan by using wizard to backup a
>> production database daily.
>> There is a request to include 2 more databases to be included in the
>> maintenance plan. I select the maintenance plan and press "Modify" but I
>> am not able to work out how to include 2 more databases. Besides, it
>> appears that both transaction log & database backup are not deleted since
>> the plan is executed, is there something wrong ?
>> Is it possible to give me some advice ?
>> Thanks
>>
>|||Dear Tibor and Uri,
Thank you for your advice.
I find that the reason why I am not able to add more databases in the task
is because I use SA in my workstation while Windows Authentication is used
at the server side. In this way, I change the connection from Windows
Authentication to SQL Authentication for both local and target servers and I
am able to do it on my workstation. I have changed the ownership of the
jobs to SA (Instead of Administrator).
I would like to seek your advice
1) Is it possible to change the ownership of the "Database Maintenance Plan"
from Administrator to SA ?
2) Is it necessary to add the "Cleanup Task" for the daily transaction log
maintenance plan so that old transaction log backup will be deleted ?
3) Which step should be performed first - Cleanup Task or Backup Task ?
Should the constraint be success or finish ?
4) Is it necessary to add another task to delete old reports in the "Weekly
Maintenance Plan" so that the logging will be deleted ?
Thanks
Peter
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O4yE4B1IHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> There is a request to include 2 more databases to be included in the
>> maintenance plan. I select the maintenance plan and press "Modify" but I
>> am not able to work out how to include 2 more databases.
> You need to add the databases to the backup task inside the plan.
> Right-lock the backup task, select "Edit..." and in the "Databases:"
> drop.down you select the databases you want to include.
>
>> Besides, it appears that both transaction log & database backup are not
>> deleted since the plan is executed, is there something wrong ?
> Add a "Maintenance Cleanup Task" to the plan.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:u01Fh30IHHA.4712@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I have created a DB maintenance plan by using wizard to backup a
>> production database daily.
>> There is a request to include 2 more databases to be included in the
>> maintenance plan. I select the maintenance plan and press "Modify" but I
>> am not able to work out how to include 2 more databases. Besides, it
>> appears that both transaction log & database backup are not deleted since
>> the plan is executed, is there something wrong ?
>> Is it possible to give me some advice ?
>> Thanks
>>
>|||> 1) Is it possible to change the ownership of the "Database Maintenance Plan" from Administrator to
> SA ?
I would guess that you would change the owner of the job. To the best of my knowledge, a maint plan
doesn't have an owner, the job does. Not sure, though.
> 2) Is it necessary to add the "Cleanup Task" for the daily transaction log maintenance plan so
> that old transaction log backup will be deleted ?
Yes, if you want the old backup files to be removed and if you don't remove them some other way.
> 3) Which step should be performed first - Cleanup Task or Backup Task ? Should the constraint be
> success or finish ?
This is really your decision. I prefer to do the backup first, and if it fails I don't remove old
backups.
> 4) Is it necessary to add another task to delete old reports in the "Weekly Maintenance Plan" so
> that the logging will be deleted ?
Yes, if you want the old report files to be removed and if you don't remove them some other way.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:%23gNfQpBJHHA.4000@.TK2MSFTNGP06.phx.gbl...
> Dear Tibor and Uri,
> Thank you for your advice.
> I find that the reason why I am not able to add more databases in the task is because I use SA in
> my workstation while Windows Authentication is used at the server side. In this way, I change the
> connection from Windows Authentication to SQL Authentication for both local and target servers and
> I am able to do it on my workstation. I have changed the ownership of the jobs to SA (Instead of
> Administrator).
> I would like to seek your advice
> 1) Is it possible to change the ownership of the "Database Maintenance Plan" from Administrator to
> SA ?
> 2) Is it necessary to add the "Cleanup Task" for the daily transaction log maintenance plan so
> that old transaction log backup will be deleted ?
> 3) Which step should be performed first - Cleanup Task or Backup Task ? Should the constraint be
> success or finish ?
> 4) Is it necessary to add another task to delete old reports in the "Weekly Maintenance Plan" so
> that the logging will be deleted ?
> Thanks
> Peter
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:O4yE4B1IHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> There is a request to include 2 more databases to be included in the maintenance plan. I select
>> the maintenance plan and press "Modify" but I am not able to work out how to include 2 more
>> databases.
>> You need to add the databases to the backup task inside the plan. Right-lock the backup task,
>> select "Edit..." and in the "Databases:" drop.down you select the databases you want to include.
>>
>> Besides, it appears that both transaction log & database backup are not deleted since the plan
>> is executed, is there something wrong ?
>> Add a "Maintenance Cleanup Task" to the plan.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Peter" <Peter@.discussions.microsoft.com> wrote in message
>> news:u01Fh30IHHA.4712@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I have created a DB maintenance plan by using wizard to backup a production database daily.
>> There is a request to include 2 more databases to be included in the maintenance plan. I select
>> the maintenance plan and press "Modify" but I am not able to work out how to include 2 more
>> databases. Besides, it appears that both transaction log & database backup are not deleted
>> since the plan is executed, is there something wrong ?
>> Is it possible to give me some advice ?
>> Thanks
>>
>|||Dear Tibor,
Thank you for your advice.
Peter
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ejNfWICJHHA.3424@.TK2MSFTNGP02.phx.gbl...
>> 1) Is it possible to change the ownership of the "Database Maintenance
>> Plan" from Administrator to SA ?
> I would guess that you would change the owner of the job. To the best of
> my knowledge, a maint plan doesn't have an owner, the job does. Not sure,
> though.
>
>> 2) Is it necessary to add the "Cleanup Task" for the daily transaction
>> log maintenance plan so that old transaction log backup will be deleted ?
> Yes, if you want the old backup files to be removed and if you don't
> remove them some other way.
>
>> 3) Which step should be performed first - Cleanup Task or Backup Task ?
>> Should the constraint be success or finish ?
> This is really your decision. I prefer to do the backup first, and if it
> fails I don't remove old backups.
>
>> 4) Is it necessary to add another task to delete old reports in the
>> "Weekly Maintenance Plan" so that the logging will be deleted ?
> Yes, if you want the old report files to be removed and if you don't
> remove them some other way.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:%23gNfQpBJHHA.4000@.TK2MSFTNGP06.phx.gbl...
>> Dear Tibor and Uri,
>> Thank you for your advice.
>> I find that the reason why I am not able to add more databases in the
>> task is because I use SA in my workstation while Windows Authentication
>> is used at the server side. In this way, I change the connection from
>> Windows Authentication to SQL Authentication for both local and target
>> servers and I am able to do it on my workstation. I have changed the
>> ownership of the jobs to SA (Instead of Administrator).
>> I would like to seek your advice
>> 1) Is it possible to change the ownership of the "Database Maintenance
>> Plan" from Administrator to SA ?
>> 2) Is it necessary to add the "Cleanup Task" for the daily transaction
>> log maintenance plan so that old transaction log backup will be deleted ?
>> 3) Which step should be performed first - Cleanup Task or Backup Task ?
>> Should the constraint be success or finish ?
>> 4) Is it necessary to add another task to delete old reports in the
>> "Weekly Maintenance Plan" so that the logging will be deleted ?
>> Thanks
>> Peter
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:O4yE4B1IHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> There is a request to include 2 more databases to be included in the
>> maintenance plan. I select the maintenance plan and press "Modify" but
>> I am not able to work out how to include 2 more databases.
>> You need to add the databases to the backup task inside the plan.
>> Right-lock the backup task, select "Edit..." and in the "Databases:"
>> drop.down you select the databases you want to include.
>>
>> Besides, it appears that both transaction log & database backup are not
>> deleted since the plan is executed, is there something wrong ?
>> Add a "Maintenance Cleanup Task" to the plan.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Peter" <Peter@.discussions.microsoft.com> wrote in message
>> news:u01Fh30IHHA.4712@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I have created a DB maintenance plan by using wizard to backup a
>> production database daily.
>> There is a request to include 2 more databases to be included in the
>> maintenance plan. I select the maintenance plan and press "Modify" but
>> I am not able to work out how to include 2 more databases. Besides, it
>> appears that both transaction log & database backup are not deleted
>> since the plan is executed, is there something wrong ?
>> Is it possible to give me some advice ?
>> Thanks
>>
>>
>sql

Monday, March 19, 2012

how to import the database data from backup file ?

Hello,All:

I have two sql 2000 servers,one for production and the other is for backup server,I used the sql agent to create bakup daily in Sql server Enterprise Manager.

Now I want to import the backup data(generated by production server),I don't know how to do it.

Is it possible to do it ? anyone can give me a soluation ?

thanks in advanced!

->Open Enterprise manager of SQL Server 2000

-> Select Your Server

-> right click on your database

-> All Tasks -> Restore Database

-> Select from Device

-> click the button Select Devices

-> in the new window select Disk option

-> click add button

-> select your backup file in file name option

-> ok

->ok

Monday, March 12, 2012

How to import mysql data into SQL Server 2000 ?

Hi all,
I have a *.sql backup file, is there any method to import the backup into
SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
Thanks a lot !Hi,
That is actually a dump file of MYSQL. You cant use that in SQL Server
directly. Ways to transfer data from MYSQL to SQL server is given below:-
1. DTS
2. Generated comma seperated text file in MYSQL and use BCP IN / to load it.
Better and easiest option is to use DTS to copy data between
Thanks
Hari
MCDBA
<.> wrote in message news:OWZ8OZ5QEHA.2404@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I have a *.sql backup file, is there any method to import the backup into
> SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
> Thanks a lot !
>

How to import mysql data into SQL Server 2000 ?

Hi all,
I have a *.sql backup file, is there any method to import the backup into
SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
Thanks a lot !Hi,
That is actually a dump file of MYSQL. You cant use that in SQL Server
directly. Ways to transfer data from mysql to SQL server is given below:-
1. DTS
2. Generated comma seperated text file in mysql and use BCP IN / to load it.
Better and easiest option is to use DTS to copy data between
Thanks
Hari
MCDBA
<.> wrote in message news:OWZ8OZ5QEHA.2404@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I have a *.sql backup file, is there any method to import the backup into
> SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
> Thanks a lot !
>

How to import mysql data into SQL Server 2000 ?

Hi all,
I have a *.sql backup file, is there any method to import the backup into
SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
Thanks a lot !
Hi,
That is actually a dump file of MYSQL. You cant use that in SQL Server
directly. Ways to transfer data from MYSQL to SQL server is given below:-
1. DTS
2. Generated comma seperated text file in MYSQL and use BCP IN / to load it.
Better and easiest option is to use DTS to copy data between
Thanks
Hari
MCDBA
<.> wrote in message news:OWZ8OZ5QEHA.2404@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I have a *.sql backup file, is there any method to import the backup into
> SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
> Thanks a lot !
>

How to import data into development database from productions data

Would it be easer to backup and restore production database on the
development server under different name?
"Sunny" wrote:

> I have two different setup, one for development and other for production.
> Two different SQL server 2000 installed on two different Windows 2000
> server. I want to import all data of selected tables from production server
> to development server. Databases name on both seerver are different. Before
> I import, I want to remove all information from selected tables from
> development database. Can anyone suggest me TSQL code?
> Thanks.
>
>
Or you can do something like this, with is not the best solution:
DECLARE @.name SYSNAME
DECLARE rs CURSOR
READ_ONLY
FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
OPEN rs
FETCH NEXT FROM rs INTO @.name
WHILE (@.@.fetch_status <> -1)
BEGIN
IF (@.@.fetch_status <> -2)
BEGIN
-- find your tables you need
IF @.name = 'Table1'
BEGIN
PRINT @.name
DELETE
FROM OPENQUERY([ServerName], 'SELECT * FROM
DevelopDatabase.dbo.Table1')
INSERT INTO OPENQUERY([ServerName], 'SELECT * FROM
DevelopDatabase.dbo.Table1')
SELECT * FROM TABLE1
END
END
FETCH NEXT FROM rs INTO @.name
END
CLOSE rs
DEALLOCATE rs
GO
But before that you have to add linked server and linked server login
"Sunny" wrote:

> I have two different setup, one for development and other for production.
> Two different SQL server 2000 installed on two different Windows 2000
> server. I want to import all data of selected tables from production server
> to development server. Databases name on both seerver are different. Before
> I import, I want to remove all information from selected tables from
> development database. Can anyone suggest me TSQL code?
> Thanks.
>
>

Sunday, February 19, 2012

How to identify a database snapshot?

Hello,

Because you can not backup a database snapshot, I'm curious to as how you identify the database as a snapshot? I need to add an exclusion to my backup scripts so that they don't attempt to backup a snapshot.

Thanks

select source_database_id from sys.databases

if source_database_id is null for a database then it is not a snapshot.

if it is not null, then the database is a snapshot and the source_database_id refers to the database from which the snapshot was created.

Also take a look at http://msdn2.microsoft.com/en-us/library/ms178534.aspx

How to identify 2005 vs 2000 backups

Can anyone guide me on how to determine if a backup is a 2005 or 2000
database. Is there some identifier bytes I can look at to determine the
correct version.
I have no problem writing a utility to scan a backup file for the correct
info (if it is necessary)
TIA
RobOn my 2000 server:
restore headeronly
from disk = 'C:\Program Files\Microsoft SQL
Server\MSSQL$SQL2000\BACKUP\Northwind.bak'
results:
SoftwareVersionMajor = 8
SoftwareVersionMinor = 0
SoftwareVersionBuild = 2039
Same in 2005
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Rob Diamant" <robdusi@.hotmail.com> wrote in message
news:u9vIGRcCHHA.144@.TK2MSFTNGP02.phx.gbl...
> Can anyone guide me on how to determine if a backup is a 2005 or 2000
> database. Is there some identifier bytes I can look at to determine the
> correct version.
> I have no problem writing a utility to scan a backup file for the correct
> info (if it is necessary)
> TIA
> Rob
>|||RESTORE HEADERONLY will give you such information. Check of the SoftwareVersionMajor column.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob Diamant" <robdusi@.hotmail.com> wrote in message news:u9vIGRcCHHA.144@.TK2MSFTNGP02.phx.gbl...
> Can anyone guide me on how to determine if a backup is a 2005 or 2000
> database. Is there some identifier bytes I can look at to determine the
> correct version.
> I have no problem writing a utility to scan a backup file for the correct
> info (if it is necessary)
> TIA
> Rob
>

How to identify 2005 vs 2000 backups

Can anyone guide me on how to determine if a backup is a 2005 or 2000
database. Is there some identifier bytes I can look at to determine the
correct version.
I have no problem writing a utility to scan a backup file for the correct
info (if it is necessary)
TIA
RobOn my 2000 server:
restore headeronly
from disk = 'C:\Program Files\Microsoft SQL
Server\MSSQL$SQL2000\BACKUP\Northwind.bak'
results:
SoftwareVersionMajor = 8
SoftwareVersionMinor = 0
SoftwareVersionBuild = 2039
Same in 2005
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Rob Diamant" <robdusi@.hotmail.com> wrote in message
news:u9vIGRcCHHA.144@.TK2MSFTNGP02.phx.gbl...
> Can anyone guide me on how to determine if a backup is a 2005 or 2000
> database. Is there some identifier bytes I can look at to determine the
> correct version.
> I have no problem writing a utility to scan a backup file for the correct
> info (if it is necessary)
> TIA
> Rob
>|||RESTORE HEADERONLY will give you such information. Check of the SoftwareVers
ionMajor column.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob Diamant" <robdusi@.hotmail.com> wrote in message news:u9vIGRcCHHA.144@.TK2MSFTNGP02.phx.g
bl...
> Can anyone guide me on how to determine if a backup is a 2005 or 2000
> database. Is there some identifier bytes I can look at to determine the
> correct version.
> I have no problem writing a utility to scan a backup file for the correct
> info (if it is necessary)
> TIA
> Rob
>

How to identify 2005 vs 2000 backups

how to hook into sql server with vbscript or C# ?

How can I do this with vbscript, or C# ?
- Copy backup files down from a network share, into the data directory of my
local sql 2005 instance
- perform a restore using the files copied from above
- Execute a dts package
More info:
Our databases are scripted and exist on the typical development, and testing
enviroments. So as I get ready to start a new application, I want my local
sql instance to be updated based on structure changes as well as data. So I
have to apply the changes from the scripted sources and pull over the data.
I would naturally like to automate this.
ideas / suggestions welcomeHello bitshift,
Three thoughts:
a. Use Visual Studio Team Edition for the Database Developer (aka Data Dude)
since it has this "in the box"
b. Look at tools like Red-Gate's SqlCompare.
c. If you insist on rolling your own (which is doable, but a lot of work),
investigate the Server Management Objects namespace in BOL (see "Getting
Started in SMO").
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||"Kent Tegels" <ktegels@.develop.com> wrote in message
news:18f2bcb127c088c9d58e6fc9fc70@.news.microsoft.com...
> a. Use Visual Studio Team Edition for the Database Developer (aka Data
> Dude) since it has this "in the box"
this isn't in my MSDN subscription except as a trial; do you know if
there's any way to get hold of it for less than the $3700 or so Programmer's
Paradise wants ?
is it an add-on that I could put on top of VS2005 or a completely separate
product? how does it compare to the Redgate tools ? where there's a
comparision of course ..|||Are you trying to do a custom log shipping? If you are, check out my blog
entry (this of course doesnt include the DTS portion) ;-)
http://bassplayerdoc.blogspot.com/2007/10/your-poor-mans-sql-server-log-shipping.html
"bitshift" <jobob@.aol.com> wrote in message
news:Obd7Kj5BIHA.5980@.TK2MSFTNGP04.phx.gbl...
> How can I do this with vbscript, or C# ?
> - Copy backup files down from a network share, into the data directory of
> my local sql 2005 instance
> - perform a restore using the files copied from above
> - Execute a dts package
>
> More info:
> Our databases are scripted and exist on the typical development, and
> testing enviroments. So as I get ready to start a new application, I want
> my local sql instance to be updated based on structure changes as well as
> data. So I have to apply the changes from the scripted sources and pull
> over the data. I would naturally like to automate this.
> ideas / suggestions welcome
>

Monday, March 26, 2012

How to initialize pull transactional subscription with attaching of a database

How to initialize pull transactional subscription with attaching of a database

Wednesday, March 21, 2012

How to include more databases in DB Maintenance Plan ?

How to include more databases in DB Maintenance Plan ?

How to include more databases in DB Mainteance Plan for SQL Server 2005

How to include more databases in DB Mainteance Plan for SQL Server 2005

Monday, March 19, 2012

how to import the database data from backup file ?

Monday, March 12, 2012

How to import mysql data into SQL Server 2000 ?

How to import mysql data into SQL Server 2000 ?

How to import mysql data into SQL Server 2000 ?

How to import data into development database from productions data

Sunday, February 19, 2012

How to identify a database snapshot?

How to identify 2005 vs 2000 backups

How to identify 2005 vs 2000 backups

How to identify 2005 vs 2000 backups

how to hook into sql server with vbscript or C# ?

hide system tables

Blog Archive

About Me