Viewing 15 posts - 391 through 405 (of 1,166 total)
Good to know this but I checked on MS site with no luck..
February 1, 2007 at 3:18 pm
To reduce the down time you restore backup/restore is the best option...
When you attach/restore your db, it will be compatibility 80 not 90. You need to change it...
Also run the...
February 1, 2007 at 2:30 pm
January 31, 2007 at 11:04 pm
Did you take a look target server /target server info in BOL...
It is very helpful to monitory from one centralized location...
January 31, 2007 at 8:01 pm
You can also create a dts package to start the job..
Use EXEC SQL TASK to execute the job...
January 31, 2007 at 7:56 pm
Make sure you have the rights...
Logon to the server open EM and check your login exists...
January 31, 2007 at 7:54 pm
Memory is not dependent on database size...
I have some servers which supports 200+ GB database with only 2GB RAM...
Read the following articles..
http://www.sql-server-performance.com/awe_memory.asp
http://support.microsoft.com/kb/274750
http://www.sqlmag.com/Article/ArticleID/44557/sql_server_44557.html
January 31, 2007 at 7:47 pm
In 2005 MP uses SSIS packages so I think you copy the SSIS package from msdb..sysdtspackages90 table where it is stored.
select
January 31, 2007 at 7:42 pm
I don't think it is default behaviour...
Are you sure you installed all of these on a clustered server?
Check the services mmc, if they are installed you should see related services...
January 31, 2007 at 7:33 pm
When you run the log backup, log will be truncated (means it will free up space) but it will not truncate the portion of active transaction/open transaction...
One open transaction should...
January 31, 2007 at 7:31 pm
Read the following article which will help to configure memory...
http://www.sql-server-performance.com/awe_memory.asp
January 30, 2007 at 10:45 pm
You schedule the trace start script in schedule job and pass trace stop date dynamically...
and you use the following script to stop the trace...in different job step or job...
declare @traceid...
January 30, 2007 at 10:43 pm
May be it is excel issue not the sql..
Check the following...
January 30, 2007 at 10:11 pm
If it is one time thing... you can download some thirdparty backup tools like LiteSpeed (demo version) for backup.
Backup your db using tool(litespeed) to multiple files so that you can copy them...
January 30, 2007 at 7:09 pm
How to set up and troubleshoot a linked server to an Oracle database in SQL Server
http://support.microsoft.com/kb/280106
January 30, 2007 at 7:03 pm
Viewing 15 posts - 391 through 405 (of 1,166 total)