Viewing 15 posts - 3,346 through 3,360 (of 7,503 total)
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...
October 30, 2009 at 4:24 am
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,...
October 30, 2009 at 4:10 am
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]
October 30, 2009 at 1:27 am
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...
October 30, 2009 at 1:22 am
Did you check the examples in Books Online ??
http://msdn.microsoft.com/en-us/library/ms189799%28SQL.90%29.aspx
October 29, 2009 at 3:05 pm
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...
October 29, 2009 at 3:03 pm
- 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...
October 29, 2009 at 2:57 pm
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
October 29, 2009 at 1:51 pm
- 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...
October 29, 2009 at 1:45 pm
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...
October 29, 2009 at 1:40 pm
repent_kog_is_near (10/28/2009)
x86-32 is where we are now.What are the factors that should influence going for 64bit environment.?
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.
October 29, 2009 at 1:32 am
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...
October 28, 2009 at 3:22 pm
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...
October 28, 2009 at 3:13 pm
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...
October 28, 2009 at 3:07 pm
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...
October 28, 2009 at 3:04 pm
Viewing 15 posts - 3,346 through 3,360 (of 7,503 total)