Viewing 15 posts - 166 through 180 (of 283 total)
You can see the errors that occured when the jobs ran in a few different ways:
In Management Studio, go to SQL Server Agent then Job Activity Monitor. Find your...
June 5, 2009 at 9:40 am
Something like Quest LiteSpeed can do the compression for you and is integrated into the job steps.
June 4, 2009 at 2:53 pm
Not sure why it doesn't save the databases you select though we had a similar problem with some of ours. Not sure if a service pack or CU fixed...
June 4, 2009 at 2:41 pm
Not sure what you mean. Do you mean you want to export from a named instance to another sql server instance but have no tools? Are...
June 4, 2009 at 8:31 am
Think you will have to keep track of the licence that each server is using via a manual process.
May 29, 2009 at 5:04 am
MSDN refers to the licencing of the software rather than the version. Only users who hold an MSDN licence can use software installed under the MSDN licence. The...
May 27, 2009 at 1:27 am
SQL Server can only use the disk resources defined in the cluster so I think you're stuck with putting tempdb on a clustered drive
May 26, 2009 at 6:12 am
Instead of a stored procedure are you able to create an import task via the import wizard and then save the package it creates and reuse it in a job?
May 22, 2009 at 1:36 am
Start SQL Server Management Studio, register your database server, connect to it, select the database and right-click, select properties, then files. Click add to add a new file and...
May 21, 2009 at 2:13 am
We have Sharepoint and the total db size is approaching 1Tb. It runs on a 4 cpu db server with 32Gb RAM. However, there are many databases that...
May 21, 2009 at 2:07 am
I've seen this error when the current datafile size is very large, the autogrow is set to be % rather than Mb and the files are on SAN. ...
May 20, 2009 at 2:16 am
You can reorganize the database using a maintenance plan or by shrinking the database in Enterprise Manager/Management Studio. This will do the equivalent of what you are doing in...
May 18, 2009 at 9:30 am
With that Oracle example you are creating a new table from an existing table. The outcome may be that the new table uses less space than the existing table...
May 18, 2009 at 5:11 am
The stored procs and functions are held in the database so will be there when you attach the datafiles. When looking at Management Studio they are in the programmability...
May 18, 2009 at 2:05 am
Viewing 15 posts - 166 through 180 (of 283 total)