Viewing 15 posts - 946 through 960 (of 1,157 total)
Please go through this MSDN documentation.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 31, 2010 at 3:28 am
Dropping a database does not leave behind the data and log files.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 31, 2010 at 1:14 am
SQL Server has just dumped the backup information to the file and the operating system did not allow the file to be processed. This backup file is irrecoverable
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 10:02 pm
Get the Service Name from services.msc for those services. As you did for the other services, use NET STOP servicename
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 10:00 pm
You can check in sys.processes to see if any backup job is running against a database. Put this logic in the Shrink TLog job step
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 9:56 pm
SYS is a scheme. Read more here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 2:19 pm
Could not see SQL Server element in the question
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 2:08 pm
Description = The server name or address could not be resolved
From the error message it does not look like an issue with SQL Server. Check the server which is being...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 1:42 pm
Just put those commands in a notepad file and save it as .bat. You are good to go !
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 10:41 am
Add an output file to the job step --> advanced. With this the job execution will be fully logged in a text file.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 10:40 am
Interview question ?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 10:07 am
The Maintenance Plans available in the SQL Server 2005 does this without the need of writing scripts.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 9:59 am
I could not find that info in any of the .xml/.ini files on DVD. Not sure how setup determines which Edition it is.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 9:24 am
The "SQL***MemoryManager" counter in Perfmon will give you the details.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 9:11 am
You may use xp_cmdshell to execute the command line parameters for the FTP command. Also you may try using SSIS
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 9:02 am
Viewing 15 posts - 946 through 960 (of 1,157 total)