If both sqlservers can "see" eachother and the destination service account has read auth on the source servers backup folder, you can restore using the source server bak files

restore database...

This is one way to work with batches:

If you don't switch to simple recovery, you log files may get filled up and even grow !

If you switch to simple recovery,...

or maybe someone just dropped the database that had been set for default database of the service account.

Solution:

ALTER LOGIN [ictlan\MSSQLSERVICE] WITH DEFAULT_DATABASE=[master]

Thank you both for clarifying how to change that behaviour at windows level;

I hadn't been looking in that direction, because in many cases, when you encounter this behaviour, it points...

Did you check the examples in Books Online ??

http://msdn.microsoft.com/en-us/library/ms189799%28SQL.90%29.aspx

the resultset of you statement is being written to your grid of text results work area.

That may indeed fill up you c drive it it is a very large...

- please provide the full statement exactly as you execute it !

(maybe even post the db create ddl)

- keep in mind, you cannot empty the primary file ! (it contains...

I bet it would go very much faster the other way around :w00t: :hehe:

Did you check these Database Mirroring Best Practices and Performance Considerations ? http://technet.microsoft.com/en-us/library/cc917681.aspx

- It is a very bad habit to use a domain admin account for sqlserver service account.

Always aim for minimal rights for any service account to keep doors as...

IMO easyest is to script it all and execute the scripts at the target instance.

Keep in mind to also script the granted usage rights.

What do you need to script ?

have...

Search SSC for "64-bit"

http://www.sqlservercentral.com/articles/News/abitabout64bit/1360/

http://www.sqlservercentral.com/articles/Miscellaneous/overviewof64bitsql/1166/

and off course at MS.

You should also be more specific as to what you are trying to ship to your client.

Content of a single table vs content of multiple tables, a filegroup, a full...

This should really be handled by your user interface.

Since you state that is not an option, I guess you will be exporting sql data using query analyser or bcp.

In that...

Lutz pointed you to Lynns great article .

One thing to keep in mind, especially with datetime, but it also goes for other datatypes:

Keep your data in the original datatype as...

just my 2ct

IMO you are trying to persist some kind of state of your "client" session.

An option can be to add a session identifier to your row a key component.

Another...