Viewing 15 posts - 2,911 through 2,925 (of 6,679 total)
raotor (12/21/2011)
4. So, the "append to existing media set" option will actually overwrite an earlier backup set if that one has expired?
No - these options are really only valid when...
December 21, 2011 at 1:11 pm
Verify that the login and user in msdb match exactly as the AD account. This is case-sensitive and must match in order for it to work.
December 19, 2011 at 12:24 pm
You need the password. It is a domain account and you cannot change it without affecting the other system.
December 13, 2011 at 8:50 pm
First, you need to add your account to SQL Server and set it up as sysadmin. Then, you can remove the sysadmin right from BUILTIN\Administrators.
Right now, you are authenticated...
December 13, 2011 at 7:25 pm
Perry Whittle (12/13/2011)
Chrissy321 (12/13/2011)
I have xp_cmdshell available on this serverNo xp_cmdshell, just execute the vb script from a SQL server agent job step
Or - look at creating a Powershell script...
December 13, 2011 at 7:18 pm
Tristan Chiappisi (12/13/2011)
You guys are getting side tracked! 🙂Let me rephrase the question:
Has anyone used a parallel network file moving software that they would recommend?
Thanks!
-Tristan
We purchase a product called RocketStream...
December 13, 2011 at 6:59 pm
Barkingdog (12/12/2011)
December 12, 2011 at 6:47 pm
Nobody has mentioned this option - which I believe is exactly what it was designed for.
Lookup Service Broker in Books Online. Using a service broker, the broker will be...
December 11, 2011 at 9:31 am
Create a group level in the report and group on the data that you want in your single row. Leave out the data that is causing the duplicate rows.
If...
December 10, 2011 at 3:36 pm
Select log_reuse_wait_desc From sys.databases
Using the above, that database will probably show REPLICATION. Is this database replicated - and if it is have you verified the replication is working?
If it...
December 10, 2011 at 3:34 pm
Here is what I would do...
Set a max size on each tempdb file so you don't exceed 100GB - since you say it normally doesn't grow much. Then, wait...
December 9, 2011 at 11:53 am
MidBar (12/6/2011)
OR
can be any dis-advantage if we write like 23/sep/2011 111213?
"YYYY-MM-DD HH:MM:SS...
December 6, 2011 at 12:30 pm
It looks like you either have a database named with a space - or, your script is returning a row with a space for a database.
Really would need to see...
December 5, 2011 at 5:43 pm
mphilippopoulos (12/5/2011)
December 5, 2011 at 5:33 pm
If you have Visual Studio - you probably have the dumpbin utility. You can use that - and then search the output for the machine.
December 5, 2011 at 12:38 pm
Viewing 15 posts - 2,911 through 2,925 (of 6,679 total)