Tagged Questions
3
votes
1answer
58 views
SP for Restoring Database and performing other tasks on it
I am creating a stored procedure for our QA dept that will do the following:
Accept specific inputs to generate a consistent name, restore a database (giving it the generated name,) set the db up for ...
2
votes
1answer
155 views
Only a single WITH MOVE clause should be specified for any logical file name
I'm trying to do a copy database by scripting a backup and restore. I have the backup procedure working correctly but I keep getting the error
Conflicting file relocations have been specified ...
0
votes
1answer
544 views
How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
I´m new to SQL Server administration.
I´d like to create automatically backup database every sunday night, if there was any change in previous week (if not, backup is unnecessary).
Is there some way ...
1
vote
2answers
1k views
BACKUP failed to complete - with spaces, for no reason
Every day my database backup fails for some databases and does fine for others. I'm calling the backup through a Stored Procedure that runs scheduled in a job. Tonight I'm going to run the procedure ...
4
votes
1answer
356 views
Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?
In SQL Server I have set up transational replication using the "initialize with backup" option. Data is being replicated fine, as are schema changes to tables. However, schema changes to stored ...
