you could use, SSIS, Import Export Data Wizard, BCP.

Quickest would be the wizard but if you want to do fancy things with the data on the copy then SSIS

SQLSvrStevo (2/27/2012)

---

Do the DR databases have to be in standby/norecovery/read-only mode? I have several databases in DR which have been fully restored (as the data is static) I just...

believe I have resolved it

i created a deadlock and it didnt fire the alert

and i was still trying to fire the same deadlock alert, but I had to create a...

you have to allow the other servers internet connectivity

we have DEV/TEST servers here in the UK locally and PROD servers in the US managed by a 3rd party.

I'm a fan...

we connect to a 3rd party ftp site, download a zip file using a http connection manager

we then have a C# script which checks the unzipping directory and clears it...

you could create an ssis package and give it a script task which will execute VB.net or C# code and then schedule the package as a job

wrap the ? in [] then test it, looks ok to me

are you talking about the SA account?

if so SQL will not allow you to continue the installation without a windows user all so being a sysadmin, if you know this...

take a look at an undocumented function called sp_msforeachdb, this will allow you to execute the same query in all databases including master model msdb and tempdb so you will...

they dont have any special ports in logshipping, they use file copy ports and whatever port SQL is running on, usually 1433 unless you have changed it or installed a...

you will need to build in a link to the system catalogs for schemas and users as they will be different in each do and then pass the values in...

Ok so you can do PIT restores.

Ok what is your backup routine? Full daily/weekly/monthly? Diffs daily/weekly/monthly TXLogs 5mins/15mins/Hourly/Daily etc

If you dont do TXLog backups then you cant do...

take a look through the url above and also backupset table and build a sp_send_dbmail query to send you the mail

you just need to grant execute on the schema in question

so if everything is in the DBO schema you would do

GRANT EXECUTE ON SCHEMA::dbo TO ixxxxxx

you could also create a...

to enable file stream, you need to first logon to the server and open up SQL Server Configuration Manager.

in the SQL Server Services section, right click the SQL Server (MSSQL.......)...