I just downloaded and installed the SQL Server 2005 Management Studio Express CTP. I have no problem connecting to any SQL 2000 servers in my...
I have a database that was 26 Gig. After I shrunk it, it got down to about 16 Gig. Over the weekend, I had an Optimization job run. Now it is back...
Is it possible to only restore an MDF file from a backup and not the corresponding LDF file. The database is in Bulk-Logged mode.
Can someone please remind me how to select a database in T-SQL? I know you can use the dropdown box in the job definition, but how do you do this in...
I have 2 servers et up in a log ship scenario. Every hour, I backup the tran log and restore it on the other server. The log backup file normally...
Separate names with a comma.