Viewing 15 posts - 1,231 through 1,245 (of 1,478 total)
There are few ways. If you want to run it as a job you can use the same script in different steps and run each step in a different...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 11, 2009 at 2:11 pm
I never used the copy database wizard, so I can’t comment about it. Detach/attach is faster then backup and restore, but it causes down time on the original server....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 11, 2009 at 9:50 am
If you want to check all databases, you can specify NULL as the value for all parameters. However I wouldn’t do that. If you want to check the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 11, 2009 at 9:31 am
jameslester78 (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.
Actually the mssqlsystemresource was introduced at SQL Server 2005
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 9, 2009 at 2:06 am
Thank you for the information. I’m sure that it will help someone else that will encounter the same problem.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2009 at 10:42 pm
Can you explain what are you trying to do? If the database was in simple mode, then there is no reason to truncate the log. If you modified...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2009 at 4:05 am
How do you run the backup? What is the error message?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 7, 2009 at 1:49 am
You need to decide how much data you can afford to loose and according to that decide on your backup policy. Depending on the requirements you can use other...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 6, 2009 at 2:07 am
It is better that you’ll answer Steve’s question because there is a good chance that you are not on the right track at all. As I wrote before there...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 6, 2009 at 1:02 am
It is very hard to understand the output of dbcc log or fn_dblog. Some might say that it is impossible:-). Although there is no much information available on...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 5, 2009 at 7:43 am
I’m sorry but I’m not sure that I understand you. Are you running the BCP as part of distributed transaction? I don’t think that you can do it....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 5, 2009 at 12:42 am
nvkumar12 (1/4/2009)
There is no DBCC Log command...in ss2k5
Yes there is, but it is undocumented. You don't have to take my word for it, you can just try run...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 4, 2009 at 9:42 pm
Can you provide the error that you are getting? It would be helpful when anyone tries to find the error. In any case I think you should also...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 4, 2009 at 8:35 am
ali.m.habib (1/4/2009)
delete and reinsert 2 thousands and more record oh, are ukiding
If you didn’t use Unicode and you also didn’t use collation that supports working with Arabic as Ascii character,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 4, 2009 at 8:03 am
AV is Anti Virus. I’ve noticed that you wrote your message in the SQL Server 2000 forum. SQL Server 2000 doesn’t have DBMail. Instead it has SQL...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 4, 2009 at 1:40 am
Viewing 15 posts - 1,231 through 1,245 (of 1,478 total)